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
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.

  • Oussama's avatar
    Oussama
    Regular Visitor
    10 years ago
    I have the same problem with a directe connection to ssas cube. My report works fine when uploaded to pbi services. Which parameter I should introduce on step7 ? Is their any save credentials option on the pbix file that I have to do?
    • KrisTea's avatar
      KrisTea
      Frequent Visitor
      10 years ago

      Hi, can someone please post a sample connection string to connect to an AS model?  My PBIX connects to an AS model rather than SQL Server database.  Thank you in advance!

      • KrisTea's avatar
        KrisTea
        Frequent Visitor
        10 years ago

        What format is step 7 of the sample program expecting???

         

        I've tried all kinds of combinations for the connection string, and I keep getting errors.  Can someone PLEASE HELP???  Much appreciated.   

         

        “Data Source=server1: port1” will open a connection to an Analysis Services instance running on port “port1” on “server1”.

         

        I've even tried importing a pbix file that connects to our local sql server db using the syntax below and I continue to get errors such as Index was out of range.  Must be non-negative and less than size of the collection.  Or I'd get Operation returned an invalid status code 'InternalServerError'.  

         

        “Data Source=xxx;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=xxx”

         Data Source=xxx;Initial Catalog=xxx