Skip to main content

Power BI

Needs Votes

Connect to Azure Tables via Shared Access Signatures

Vote (210) Share
rg's profile image

rg on 28 Sep 2015 20:26:11

Today we can connect to table storage only using the storage account name and the account key.
This is not a nice way, because anyone who has this account name and key can do anything with our data (with VS, or other tools). I’ts especially dangerous when to need to share your data with someone else ..
It would be great to connect to an table storage with Shared Access Signatures.
We could just generate read-only access key to the data stored in the table storage , we can even give an expiry time :)
It would be a nice clean and safe solution!

Comments (13)
rg's profile image Profile Picture

337213b7 0f4d-4336-b511-98ce338d79bb on 05 Jul 2020 22:33:31

RE: Connect to Azure Tables via Shared Access Signatures

Power BI needs to use shared access signatures as the primary method to access Azure Storage objects.

It makes no sense for the data owner to surrender the key to a report developer, just because Power BI does not support other authentication mechanism.

This limitation forces us to move away from Azure Storage as a trustable data store.

rg's profile image Profile Picture

cfa776af d622-4e69-a017-250701d3985a on 05 Jul 2020 22:30:34

RE: Connect to Azure Tables via Shared Access Signatures

Great idea. We have the same challenge.

rg's profile image Profile Picture

604242b7 b48a-459a-85f1-320db05dcd9b on 05 Jul 2020 22:10:33

RE: Connect to Azure Tables via Shared Access Signatures

This would be good for all Azure storage types including blob. Storage account key permissions are too broad.