Change the data source of the Power BI data models

[AkkiDev]

Hi,

I am new to the Power BI reports creation. I already have multiple data models on the Power BI service.

is there any easy way to change the data source of the model?

Thanks

[Anonymous · Accepted solution]

Hi @AkkiDev ,

Where do you want to change the data source? Power BI Desktop? Or Power BI Service?

Power BI Desktop:

 Change data source from Settings Menu

1. Click File.
2. Click Options and settings.
3. Right-click Data sources settings and change source.

Change data source from Advanced Editor

1. Click Edit Queries and add the new source table.
2. Click on the new source table and select Advanced Editor.
3. Copy the commands with CTRL-C and click Done.
4. Click on the old table and click on Advanced Editor.
5. Select all the commands here, and paste the new source information using CTRL-V.
6. Apply the changes.

More details: How To Change Data Source Of Existing Report In Power BI

Power BI Service: 

Try using Power BI Rest API or XMLA endpoints to change data sources of Power BI dataset.

More details: 

Using XMLA endpoints to change data sources in a Power BI dataset 

Datasets - Update Datasources In Group 

Change Data source In Power BI Service 

If I have misnuderstood your meaning, please provide more details with your desired

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.