Error: Failed to update data source credentials

Status: Needs Info
by tondeli Regular Visitor on ‎05-11-2017 02:26 AM

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:



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

Status: Needs Info
by tondeli Regular Visitor
on ‎05-11-2017 02:48 AM

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

by Moderator v-qiuyu-msft
on ‎05-11-2017 07:15 PM

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

by Vicky_Song Established Member
on ‎05-11-2017 07:16 PM
Status changed to: Needs Info
by tondeli Regular Visitor
on ‎05-12-2017 04:23 AM




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

by tondeli Regular Visitor
on ‎05-12-2017 04:44 AM
390 {"error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError",
"detail":{"type":1,"value":"Cannot open server 'servernamehere' requested by the login.
Client with IP address '' 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."}},
{"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.

by RasikaOgale Frequent Visitor
on ‎05-14-2017 11:40 PM

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

by tondeli Regular Visitor
on ‎05-15-2017 12:15 AM

This list


doesn't include listed IP in my error message!

by RasikaOgale Frequent Visitor
on ‎05-15-2017 03:25 AM
where does need to add this IP ?
by tondeli Regular Visitor
on ‎05-15-2017 03:35 AM

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?

by Moderator v-qiuyu-msft
on ‎05-16-2017 02:50 AM

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


Best Regards,
Qiuyun Yu