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