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
This tutorial How to use Power BI Embedded with REST helped me set the credential for my datasource. I was not able to set them using the option 7 of the provision example, I used a Rest client like PostMan and followed the article specifically the part in "Data Source Connectivity (and multi-tenacy of data)".
You can see the format of the connection string in the article.