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” Image ModifiedSearch for “Azure Table Storage” and select the option Image ModifiedEnter the “Base URL” (simular to the Base URL as earlier configured in BC) Image ModifiedSign 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: Image ModifiedSelect the Tables which you would like to include in your report and click “Load” Image ModifiedFinally, 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. Image ModifiedClick “Transform Data” Image ModifiedThe Power Query Editor opens. Click on the icon in the “Content” column. Image ModifiedUncheck “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. Image ModifiedAll columns are shown now. Click on “Close & Apply” to close Power Query Editor. Image ModifiedYou are ready to start building your report! Image Modified |