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.
- Select the Booking query from the Queries list on the left, then select Navigation from APPLIED STEPS on the right.
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.
- Click OK.
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.
- 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.
- Click Delete to confirm you wish to delete the step.
- 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.