cancel
Showing results for 
Search instead for 
Did you mean: 

Error: Failed to update data source credentials

I have published one report to my own workspace and to shared workspace. I get update schedule working in my own workspace but in shared workspace I cannot set up credentials because of the following error:

 

error.png

Is there anything that I'm doing incorrect or what is this sorcery?

Status: Needs Info
Comments
Regular Visitor

In my dataset I have two data sources: Excel file from OneDrive (works) and Azure SQL database (gives the error).

Moderator

Hi @tondeli,

 

From your description, the same report exist both in My workspace and a group space, you are able to set credential for data sources in My Workspace while can't do it in the group workspace, right?

 

In your scenario, please run the Fiddler then repeat the steps to edit credential. Share .saz file here. You can upload trace file to OneDrive and share the link here.

 

Best Regards,
Qiuyun Yu

Established Member
Status changed to: Needs Info
 
Regular Visitor

@v-qiuyu-msft

@Vicky_Song

 

Does generated .saz file contain sensitive information like user names or passwords?

Regular Visitor
390 {"error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError",
"pbi.error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError",
"parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode",
"detail":{"type":1,"value":"-2146232060"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage",
"detail":{"type":1,"value":"Cannot open server 'servernamehere' requested by the login.
Client with IP address 'xx.xx.xxx.xxx' is not allowed to access the server.
To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule
on the master database to create a firewall rule for this IP address or address range.
It may take up to five minutes for this change to take effect."}},
{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2146232060"}},
{"code":"DM_ErrorDetailNameCode_UnderlyingNativeErrorCode","detail":
{"type":1,"value":"40615"}}]}}} 0

Does this error mean that I need to open yet another IP address to Azure SQL Firewall? I have already done that but the IP is different this time.

Frequent Visitor

I am Also facing same problem, pleased sggest the solution on it.PowerBiAnalyticsError.JPG

Regular Visitor

This list

 

https://www.microsoft.com/en-us/download/details.aspx?id=41653

 

doesn't include listed IP in my error message!

Frequent Visitor
where does need to add this IP ?
Regular Visitor

I need to add that IP-list to my SQL firewall settings.

 

...and my IP is listed (I didn't know how to read that list). So, what I need to do is to add that list into my firewall rules. Anyone know how to do that from .xml file, not sure how effective it is to input those IPs manually every week?

Moderator

@tondeli@RasikaOgale You can upload .saz file to your OneDrive and share the link in private message.

 

Best Regards,
Qiuyun Yu