Forum Discussion

hervema's avatar
hervema
Microsoft Employee
6 years ago

Change Datasource In report

Hello,   I developed a report in a development environment, whose data comes from a local SQL server. The report has to be deployed on a production environment pointing to the corresponding product...
PBI Report Server Datasource
bradsy's avatar
bradsy
Microsoft Employee
6 years ago

Manage\Data Sources on the report.

  • hervema's avatar
    hervema
    Microsoft Employee
    6 years ago

     Of course not, that would have been the right thing to do of course, but it is not possible to modify the data source once deployed (grayed out) 😞

    • Flynn's avatar
      Flynn
      Frequent Visitor
      6 years ago

      Hi all,

       

      having the same issue. It's not possible to realize a professional development pipiline yet.

      My Workaround:
      Work with an alias for the sql server in file C:\Windows\System32\Drivers\etc\hosts
      Use the same alias with different hosts in every environment and use this alias in the Power BI Report.

       

      Best Regards

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        This is indeed very annoying.

         

        In order to work around it, everytime we want to deploy a report to production we copy it to a staging VM with Power BI Desktop installed, open the report and change the datasources to production and then deploy it to the production Report Server.

         

        I believe that the reason they do not allow the change directly is that the data inside the report would still be from the developpment environment until the next scheduled refresh but they could simply force a refresh after changing a data source.