Configure the table and query

Point query to the right table

There are likely to be many tables in your Azure table storage area so you need to tell Power BI which table to use.

Once you have completed the following for the Booking query, you will need to repeat the steps for the Booking vs Time query.

1. Select the Booking query from the Queries list on the left, then select Navigation from APPLIED STEPS on the right.

2. Click Edit Settings in the yellow Expression.Error box.
   

3. In the Navigation popup window select Booking and click OK.
   

*When you repeat these steps for the Booking vs Time query, select Booking from the above list again.

Load all columns in the Azure table

Power BI doesn’t automatically read the entire contents of a table so you need to tell it which columns to import.

4. Click the two-arrow icon to the right of the Content column.
   

5. Make sure Use original column name as prefix is not ticked then click Load more.
   

*You may see the message Limit of 1000 scanned rows reached which can be ignored.

6. Click OK.

7. If you see the Insert Step warning, click Insert.
   

Delete the Promoted Headers step from the query

Your Azure table storage has column names built-in so we don’t need the Promoted Headers step of the query.

8. Select the Booking query from the Queries list on the left, then in APPLIED STEPS on the right, click the X next to Promoted Headers to delete the step.
   

9. Click Delete to confirm you wish to delete the step.

10. Repeat the steps above for the Bookings vs Time query.

Once the steps have been completed for both queries, continue to the next topic to set privacy levels and apply changes.

*The Booking vs Time query may show a yellow warning triangle for a few minutes whilst the query is updated. You do not have to wait for it to complete before continuing with these instructions.