Error: Failed to update data source credentials

Status: Needs Info
by tondeli Frequent 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:

 

error.png

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

Status: Needs Info
Comments
by tondeli Frequent 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 Moderator Vicky_Song
on ‎05-11-2017 07:16 PM
Status changed to: Needs Info
 
by tondeli Frequent Visitor
on ‎05-12-2017 04:23 AM

@v-qiuyu-MSFT

@Vicky_Song

 

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

by tondeli Frequent Visitor
on ‎05-12-2017 04:44 AM
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.

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 Frequent Visitor
on ‎05-15-2017 12:15 AM

This list

 

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

 

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 Frequent 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