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)
RE: Connect to Azure Tables via Shared Access Signatures
Hi, you can already do it without limitation using advanced web connector. Everything explain here: https://blogs.msdn.microsoft.com/chmitch/2018/05/31/connecting-to-blob-storage-with-a-shared-access-signature-in-power-bi/.
It's a bit tricky but fully functionnal !
RE: Connect to Azure Tables via Shared Access Signatures
Please see this article if you are still struggling with the rest API row limit, I hope it might help you https://medium.com/@martijnlentink/azure-table-storage-in-power-bi-with-a-shared-access-signature-token-dde6524b01c
RE: Connect to Azure Tables via Shared Access Signatures
REST API restricts access to a single table, and the volume of records. Discouraging to not be able to grant PowerBI limited rights into the storage account.
RE: Connect to Azure Tables via Shared Access Signatures
Hi, REST API works and is very helpful. But I think that maximum number of entities is limited 1,000 because of REST specification.
RE: Connect to Azure Tables via Shared Access Signatures
This can be done already, it's just not overly obvious as it needs to be done via the REST API.
PowerBi -> Get data -> from web -> advanced:
URL Part 1: https://SOMEACCOUNT.table.core.windows.net/
URL Part 2: SOMETABLE/
URL Part 3: *FullSASToken* for example (?sv=2017-11-09&ss=bfqt&srt=sco&sp=rwdlacup&se=2018-10-11T07:59:01Z&st=2018-10-10T23:59:01Z&spr=https&sig=BLABLABLAsomeSIG)
Header -> Accept: application/json;odata=nometadata
Works for me at least, hope it helps someone else.
RE: Connect to Azure Tables via Shared Access Signatures
This can be done already, it's just not overly obvious as it needs to be done via the REST API.
PowerBi -> Get data -> from web -> advanced:
URL Part 1: https://SOMEACCOUNT.table.core.windows.net/
URL Part 2: SOMETABLE/
URL Part 3: *FullSASToken* for example (?sv=2017-11-09&ss=bfqt&srt=sco&sp=rwdlacup&se=2018-10-11T07:59:01Z&st=2018-10-10T23:59:01Z&spr=https&sig=BLABLABLAsomeSIG)
Header -> Accept: application/json;odata=nometadata
Works for me at least, hope it helps someone else.
RE: Connect to Azure Tables via Shared Access Signatures
Hi, did this ever get implemented?
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.