Forum Discussion

Tadder's avatar
Tadder
Icon for Helper II rankHelper II
8 years ago
Solved

Data Source Changing

I have a dataset coming via our current SQL Server named "ABC".  We are getting ready to upgrade to SQL Server 2017 and when we do the name will change to "DEF".  The database name and table structur...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    Tadder,

    As long as you have same table structures for the changed server, you don't need to re-create the whole report in Power BI Desktop.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Tadder,

You don't have to re-create all Power BI reports. Just go to Files->Options and Settings->Data source settings, then choose your data source and change the server name.



" I have maybe 100 Excel reports with SQL data behind them"

In addition, could you please describe more about the above Excel reports.

Regards,
Lydia

  • Tadder's avatar
    Tadder
    Icon for Helper II rankHelper II
    8 years ago

    Thanks Lydia - I'm hoping that works for the Power BI reports.  for the Excel ones - in the past if I change the dataset source the mapping to any pivots or charts gets reset so it all has to be redone.  I'm hoping that is not the case.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Tadder,

      As long as you have same table structures for the changed server, you don't need to re-create the whole report in Power BI Desktop.

      Regards,
      Lydia

      • Tadder's avatar
        Tadder
        Icon for Helper II rankHelper II
        8 years ago

        That would be great.  I hope the same is true for all my Excel reports!