Forum Discussion
Error when updating connection string in Power BI Embedded
mjohannessonavdknijffJorgeDiegopridgeperil49
At the moment I post, I can update the connection string with the option 7 in this power-bi-embedded-integrate-report-into-web-app. Only when I type a wrong datasetID, can I get the same error. Can you try to get the datasets with option 8.Retrive a list a datasets published to a workspace and ensure you've input the correct datasetid?
This issue has now been corrected by Microsoft, at least in West Europe, so now it's working for me.
mjohannesson instead of a NotFound exception I now get a BadRequest, but I can update the connectionstring... What is the format of your connectionstring?
This is the format I´m using:
Data Source=yourDataSource;Initial Catalog=yourDataBase;User ID=yourUser;Password=yourPass;
I hope it helps you.
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"}}]}}}
