How to Change Data Source in Power BI

Quick summary

This guide shows you how to change a data source in Power BI by navigating through the Power Query Editor and updating connection settings without rebuilding your report from scratch.

Steps

1. Open Power BI Desktop and load the report whose data source you want to change.
2. Click the Transform Data button in the Home tab to open the Power Query Editor.
3. In the Power Query Editor ribbon, find and click Data Source Settings.
4. In the Data Source Settings window, select the data source you want to modify and click the Change Source button.
5. Enter your new connection details based on your source type.
6. Click OK to save your changes, then click Close to exit — your report is now connected to the new data source.