Home » Power BI » Power BI – Change Datasource

Power BI – Change Datasource

Power Bi Change Datasource Settings

In Power BI using Power Query Editor you can change the Data source.  Power BI provides many ways to change data source,  let’s understand with an example.



Approach 1:

Step-1: Go to Home tab in Power BI header menu, under this click on Edit Queries.

Edit Queries in Power Bi

Edit Queries in Power Bi

Step-2: Power Query Editor window opens then click to Data source setting.

Datasource setting

Datasource setting



Step-3: Now select your existing datasource which you want to change and click on Change Source.

Select Data Source

Select Data Source



Step-4: SQL Server Database screen appears, now write your server & Database name then click to OK.

Change Datasource Power Bi

Change Datasource Power Bi

Step-5: Now click on close button then click to Close & apply left side top corner.

Make sure your new database contains all old database tables, queries with same name & definition, otherwise your report visuals will not work.

Approach 2:

Step-1: Under Power Query Editor, select your Dataset then click on source setting icon.

Power Query Editor mode

Step-2: After that SQL server Database screen appear, write your server & Database name and you can also change your query from here.

Step-3: After all steps click to OK, then Close & apply.



How to replace Data Source for existing report?

Step-1: Under Power Query Editor, select Dataset then click to Advance editor.

Change Data Source Advance Editor

Change Data Source Advance Editor

Step-2: Advance Editor window appears, now change your server & database name and click on Done.

Advance Editor Power Bi

Advance Editor Power Bi





Hope you enjoy the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.

Leave a Reply