Forum Discussion
Connecting with connection string for Azure Storage Table
Anonymous,
When connecting to Azure Table Storage in Power BI Desktop, it requires Account name and Account key.
In your scenario, when the client wants to reuse the connection string, the client should also provides a relevant account name and account key that has access to the Azure Table Storage. And to ensure the connection is correct, go to Advanced Editor of the successful query, copy all the code, then add a new blank query and paste the code to Advanced Editor of the blank query.
Regards,
Lydia
Okay so the problem is that the client doesn't manage the table storage. The azure admin at my company does, and he does not want to share the account name and account key with the client (which is fair). The client needs access to the table storage for reporting purposes, but should not be allowed to write or anything.
So the client does not have a account name/key.
Regards,
Jeroen
What you want is support in Power BI for accessing Azure Table Storage with Shared Access Signatures - these can be generated via the Azure Storage APIs to limit access to certain tables (or collections/blobs in the case of Blob Storage) for a certain period of time.
Unfortunately for you I suspect that Power BI doesn't currently support Shared Access Signatures. Yet another thing to be added to ideas.powerbi.com... (a few moments later) ... looks a request for this has already been made; go vote! https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9953427-connect-to-azure-tables-via-shared-access-signatur
Maybe create a second Azure Storage Account for this particular client and replicate data across using AzCopy?
Anonymous,
What operation does the client want to do? If he wants to create his own visualizations, consider to publish the PBIX file to Power BI Service, share the report to the client. Then the client can use Analyze in Excel feature to connect to the dataset in Excel, and create visuals in Excel.
Regards,
Lydia
