Forum Discussion
Connecting with connection string for Azure Storage Table
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?