How to change data souce from dev sharepoint list to production sharepoint list?

[JananiMurugan_1]

I desinged power bi desktop model and report data from dev sharepoint site lists?now i want to change the data souce setting to map production sharepoint site lists.

[negi007 · Accepted solution]

@JananiMurugan_1 

Option 1:  you can change the datasource like below

Option 2:  go to powerquery editior and right click on the table and then advance editor. Here you can change the path in the code

i hope these methods help you.

[PC2790]

Make use of parameters here to ensure smooth transition.

Refer- Dynamic Power BI reports using Parameters - Guy in a Cube

If you want to do it in Power BI desktop all at once, refer this amazing video form guy in a cube- INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel - YouTube

Ideally, you should be using deployment pipelines for managing the reports across different environments.