Forum Discussion
GerwinG
10 years agoNew Member
PowerBI Embedded Sample Connection string
I've been testing with the PowerBI Embedded sample files. https://azure.microsoft.com/nl-nl/documentation/articles/power-bi-embedded-get-started-sample/ Everything is working fine except a direc...
alladisai
9 years agoRegular Visitor
Please use a "Direct query" option (not import) when you are building the .pbix file. Once you do this deploy using option 6 then use the option 7 to update the connection string.
use the connection string in below format
"Data Source=xxxx.database.windows.net;Initial Catalog=dbName;User ID=xxx;Password=xxx;"
Note : this will work only for Sql server (not sure for other servers)
Regards
Sai
krish_powerbi
9 years agoNew Member
I have updated Connection string in the same format, then option 7 giving username and password for Azure SQL it says not data source found, please suggest me, Thanks.