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.
  1. Click Edit Settings in the yellow Expression.Error box.
  1. In the Navigation popup window select Booking and click OK.

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.

  1. Click the two-arrow icon to the right of the Content column.
  1. Make sure Use original column name as prefix is not ticked then click Load more.
  1. Click OK.
  1. 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.

  1. 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.
  1. Click Delete to confirm you wish to delete the step.
  1. 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.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
Condeco Support

Post Comment