Invalid credentials to Azure blob from PBI service

[Rajat123]

Context - I connected to azure blob from PBI desktop and it connected without any issues

Issue - When i published the dashboard to the service, there is an error with refreshing saying me that i have invalid credentials for azure blob which is the same one i used while connecting successfuly from PBI desktop

Help Needed - How can I remove this error and connect to azure blob successfully from PBI service?

Error

Failed to update data source credentials: The credentials provided for the AzureBlobs source are invalid. (Source at https://krokp2.blob.core.windows.net/.)Hide details

Activity ID:	ff73b2a0-8ad3-4a61-9f31-290199c8b884
Request ID:	948ca85b-bb39-c0cb-f34f-d9a41c06b2bd
Status code:	400
Time:	Wed Jun 03 2020 19:16:12 GMT+0200 (Central European Summer Time)
Service version:	13.0.13456.212
Client version:	2005.4.01272-train
Cluster URI:	https://wabi-us-north-central-redirect.analysis.windows.net/ Last refresh failed: Wed Jun 03 2020 18:49:26 GMT+0200 (Central European Summer Time) Scheduled refre...Hide details Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh. Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net Activity ID: ff73b2a0-8ad3-4a61-9f31-290199c8b884 Request ID: fd3f1f28-4c09-37e2-eb78-6bbbce53560a Time: 2020-06-03 16:49:26Z

[Icey]

Hi @Rajat123 ,

Please try to use gateway to refresh data though the data source is in cloud.

Reference: Not able to connect with storage account for Azure backup report.

---

We are trying to go an alternate route and use an on-premise data gateway. In my opinion, this is the biggest missing link the Microsoft's analytics stack. There are many questions about how to access Storage in this forum and Microsoft does not have a realistic answer for it, other than to add hundreds of IPs to the storage whitelist (even though there is a limit on Storage firewall rules) or to remove the firewall altogether. The latter is not possible in many scenarios because it increases risk significantly.

The only thing you can do is upvote this idea: https://feedback.azure.com/forums/217313-networking/suggestions/37412272-storage-account-firewall-ad....

---

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi there

As the error says you need to go into the dataset settings, click on Data Source Credentials and put in the valid credentials for your Azure Blob Storage account.

Once that is done you will then be able to refresh the dataset.

[Rajat123]

Yes, I refreshed the azure credentials in data source as well and that's how I got the second error mentioned in my post. It says the credentials as not valid

[GilbertQ]

Hi there

From your error message it is certainly an issue with the credentials for the data source.

If you could confirm and make sure that they are correct and working?
Maybe they have expired