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 (16)
RE: Connect to Azure Tables via Shared Access Signatures
Any update on this functionality?
RE: Connect to Azure Tables via Shared Access Signatures
Azure Tables with SAS would solve a lot of problems.
RE: Connect to Azure Tables via Shared Access Signatures
I agree. To be truly able to use that component from Power BI, we really need to access it through Shared Access Signatures.
An Access Key should only be used for administration purposes. We cannot give them to Business Users.
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.
RE: Connect to Azure Tables via Shared Access Signatures
Great idea. We have the same challenge.
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.