Forum Discussion

gjross's avatar
gjross
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Connection 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...
Need Help
Infero's avatar
Infero
Icon for Advocate I rankAdvocate I
10 years ago

Hey, I also am having a problem here, just wondering, did you find the right format ? or a workaround ?

  • gjross's avatar
    gjross
    Icon for Advocate II rankAdvocate II
    10 years ago

    I built a new workspace and ran the project again, this time, when running Option 7, I only updated the username and password. I hit enter to skip updating the connection string - and it worked.

    • Brian_M's avatar
      Brian_M
      Icon for Continued Contributor rankContinued Contributor
      10 years ago

      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

      • gjross's avatar
        gjross
        Icon for Advocate II rankAdvocate II
        10 years ago

        Perfect, thank you.