Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI Report Still Connecting to Development SQL Server Instead of Test SQL Server

We are facing an issue where our Power BI report in the Test workspace is connecting to the development SQL Server database instead of the intended test SQL Server database. We deploying report from Development to Test workspace by using the deployment pipeline. We provide the Test datasource detail in deployment rules as well.

 

Specifically, we suspect that the connection information (including the database name and credentials) might be stored within the Power BI report itself, particularly as we are using DirectQuery mode or Import mode with a gateway.

 

Could someone advise on how to ensure that the Power BI report correctly connects to the test SQL Server database when we using we are using DirectQuery mode or Import mode for the data load? 

 

Thank you.

Interesting Links
Need Help
Tips and Tricks
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    Hi Anonymous 

     

    Using the deployment rules should change your data source connexions as long as there are the valid parameters in your PBI file. If it is not correct, I would suggest using the XMLA endpoint to validate that is using a valid data source.

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi Anonymous 

     

    Using the deployment rules should change your data source connexions as long as there are the valid parameters in your PBI file. If it is not correct, I would suggest using the XMLA endpoint to validate that is using a valid data source.