Forum Discussion

GerwinG's avatar
GerwinG
New Member
10 years ago

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...
Need Help
AnuragR's avatar
AnuragR
Regular Visitor
9 years ago

Did you get the issue resolved?
I am stuck at same place with same exception

Please share a solution

Thanks

alladisai's avatar
alladisai
Regular Visitor
9 years ago

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