It is possible to connect directly to Azure Table Storage using Microsoft PowerBI.
This is an excellent solution for less complex reports for which a Data Warehouse is unnecessary

Open PowerBI and click on “Get Data”
Choose “More”

Search for “Azure Table Storage” and select the option


Connect with Azure Table Storage

Enter the “Base URL” (simular to the Base URL as earlier configured in BC)


Enter Base URL

Sign in to the Azure Portal and find your account key, which is needed to connect. More information can be found here. Copy your Account key.
Paste the Account key in PowerBI:


Enter Account key

Select the Tables which you would like to include in your report and click “Load”


Select tables

Finally, you need to expand the actual “Data columns”. This is necesarry because of the connection method between PowerBI and Azure Table Storage. Click on the “Table view” icon.


Select “Table view”

Click “Transform Data”

The Power Query Editor opens. Click on the icon in the “Content” column.

Uncheck “Use original column name as prefix”. You can leave this check if needed, but this will result in long(er) column names in PowerBI. Click “OK” to close this screen.

All columns are shown now. Click on “Close & Apply” to close Power Query Editor.

You are ready to start building your report!

Replica365 PowerBI Reports

Querying Azure Table Storage

Related content