Forum Discussion
gjross
Advocate II
Advocate IIConnection String for Embedded report which uses DirectQuery
I have a PBIX which uses a Direct Query to a SQL Azure database. I have followed the steps in https://azure.microsoft.com/en-gb/documentation/articles/power-bi-embedded-get-started-sample to create a...
Yes that will work as it retains the connection string from the .pbix file you upload. If you want to programmatically change the connection string (e.g. to switch between DEV/TEST/LIVE) then I believe this should help?
https://msdn.microsoft.com/en-us/library/azure/mt711505.aspx
A very useful article is How to use Power BI Embedded with REST under the heading "data source connectivity" I found
very useful info how to set connection strings and set credential to the datasource. I could not make it using the provisioning sample option 7 and following the articles advise I used a rest client like PostMan and send the requests,
Hope I helped!