Open the Power Query Editor

Depending on your Power BI version, click Edit Queries or Transform Data from the home ribbon.

The Power Query Editor window will open.

Change the data source to read your Azure table storage

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

  1. Select the Booking query from the Queries list on the left and select Source from APPLIED STEPS on the right.

The data source of the selected query is shown in the formula bar. Currently, it is reading from the sample Excel file.

  1. Delete the entire Excel.workbook command from the formula bar.
  1. Enter your Azure table storage source in the formula bar, in the format:
= AzureStorage.Tables("[https://myazuretables]")

Replace [https://myazuretables] with the URL for your data.

  1. The first time you follow these steps you will see “Please specify how to connect” in a yellow banner:
    1. Click Edit Credentials.
    2. Enter your Account key and click Connect:
  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 load columns in the Azure table.


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