Not able to connect with storage account for Azure backup report

[Anonymous]

Hi All,

I am trying to create an Azure Backup report using PowerBI but during this i am not able to connect my storage account with PowerBI. I am getting below mention error:-

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

Activity ID:	745e71b2-XXXX-XXXXX-9fdf-1404a298d0e4
Request ID:	3c7fc7e0-XXXX-XXXXX-e0f3-c073052ff531
Status code:	400
Time:	Tue Oct 02 2018 16:14:10 GMT+0530 (India Standard Time)
Version:	13.0.6781.189
Cluster URI:	https://wabi-XXXXX-XXXXX-redirect.analysis.windows.net

I am following THIS LINK to configure backup report. I have given Key1 and Key2 both for this configuration and regenaretd keys as well but no luck !

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Please check your Azure Blob storage firewall configuration, the firewall setting of the azure storage account need to whitelist the IP address of the Power BI Service. If these IP address are not whitelisted, the access will not succeed.

Regards,

Lydia

[realolap]

Hi, 

That is quite a list to add.. one bye one. Would be nice if storage also supported a tickmark for allowing access from PowerBI, since this apparantly is not included in "Trusted Microsoft Services"

[phetzel1]

I feel like this should be reopened. The link provided in the accepted answer is deprecated. Even if that link were not deprecated, it would not be feasible to keep the Storage Firewall in sync with so many rules for the Power BI Service. What is the alternative? Is the Power BI Service a "Trusted Microsoft Service" that can bypass the firewall? Should users host a Power BI Report Server on a VM and whitelist that IP address?

[Justair07]

@phetzel1 I'm trying to solve the same issue here:

https://community.powerbi.com/t5/Service/The-credentials-provided-for-the-AzureBlobs-source-are-inva...

I spent a lot of time trying to whitelist the IP's but nothing worked. Have you had any luck?

[phetzel1]

@Justair07 : 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....