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?

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.

Highlighted
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"}}]}}}

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors