cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Not able to connect with storage account for Azure backup report

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 !

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft
Microsoft

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yuezhe-msft
Microsoft
Microsoft

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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"

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?

@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?

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors