Forum Discussion
Data source credentials (SSA token) for Azure Blob Storage only on storage account level?
Hello Rongtie,
and thank you for your answer.
1. The SAS token for the container is valid. We use it in other applications, where it works.
2. The SAS token is passed correctly. As explained above, when we use, with the same syntax, an SAS token that is authorized for the full storage account, everything works.
3. We did that (see my post above, sentence below the screenshot), and it works. BUT: We do NOT want everybody to have access to the full storage account, but only to the data in a specific container.
As I wrote above, my question is:
Is it possible to use an SAS token authorized only on a container level in PowerBI for the Web/Power BI Workspace, or are only SAS tokens authorized on a storage account level accepted? To us, the latter seems to be the case. Is there any kind of documentation on this?
Best regards,
Jan
Having the same problem as you describe.
It seems like as soon as you upload the report to the service, the power bi service seems to only recognize the top level storage account as a datasource, and not the container.
Feels like this is some kind of a bug as it works fine on Power BI desktop.
If you find any workarounds, please let me know in here! Thanks 🙂
Hi JanSchuppius ,
Are you facing the same issue on dataflow?
Please refer this -
https://learn.microsoft.com/en-us/power-query/connectors/data-lake-storage
https://learn.microsoft.com/en-us/power-query/connectors/azure-blob-storage
I hope it will be helpful.
Thanks,
Sai Teja
Hello Sai, this is NOT an issue with PowerQuery. There, everything works as intended. This is an issue with the automated updating feature for a report in a PowerBI workspace. The documentation links you gave are not helpful, unfortunately.
