cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JorgeDiego Regular Visitor
Regular Visitor

Re: Error when updating connection string in Power BI Embedded

For me is also working. Smiley Happy

JBeyers Regular Visitor
Regular Visitor

Re: Error when updating connection string in Power BI Embedded

@mjohannesson instead of a NotFound exception I now get a BadRequest, but I can update the connectionstring... What is the format of your connectionstring?

Highlighted
JorgeDiego Regular Visitor
Regular Visitor

Re: Error when updating connection string in Power BI Embedded

This is the format I´m using:

 

Data Source=yourDataSource;Initial Catalog=yourDataBase;User ID=yourUser;Password=yourPass;

 

I hope it helps you.

JBeyers Regular Visitor
Regular Visitor

Re: Error when updating connection string in Power BI Embedded

It was the one I was always using. Problem lies with the fact that there was not set a firewall rule for the Gateway. Once I granted access to the database for the specific IP Address the problem was solved. I only got the IP Adress by using the PowerBI-CLI. 

 

[ powerbi ] {"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 'engiep-dev-weeu-sql' requested by the login. Client with IP address 'xx.xx.xx.213' 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"}}]}}}