Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change sql server connection string in .pbix file

How can we change sql server connection string in .pbix file, Database server is not accessible from my local machine, It's only accessible through PowerBI report server. I cant change datasource and save report in PowerBI Desktop as I am unable to connect to Database

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous you can create a parameter for your connection string in pbix and replace that to your tables using advanced editor.

     

    once report is published to the service, goto your dataset and change the parameter value to connect to other sql server.

     

     

     

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous you can create a parameter for your connection string in pbix and replace that to your tables using advanced editor.

     

    once report is published to the service, goto your dataset and change the parameter value to connect to other sql server.