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
Enter the “Base URL” (simular to the Base URL as earlier configured in BC)
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:
Select the Tables which you would like to include in your report and click “Load”
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.
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!
