How to Change the Data Source Type in Power BI

[kannanAhammed]

Hi,

I have similar SharePoint sites (with list) through out a site collection. 

I use power BI to create dashboards. Since all the site have lists with same structure i was wondering if there is a way, we can use existing power bi files to make some changes so that it works for the newly created sites as well.

I Have tried the below, but all the custom changes such as changing the datatype etc are gone, once I applied the below technique

https://www.youtube.com/watch?v=_8dJ--ktU4c 

[amitchandak]

@kannanAhammed , refer

https://community.powerbi.com/t5/Desktop/How-to-replace-Data-Source-for-existing-report/td-p/58947

https://www.youtube.com/watch?v=_8dJ--ktU4c

[harshnathani · Accepted solution]

Hi @kannanAhammed ,

See if these help

https://community.powerbi.com/t5/Desktop/Change-Data-source/m-p/1179038

https://community.powerbi.com/t5/Desktop/Change-Data-Source-from-Local-Desktop-to-Sharepoint/td-p/50...

https://community.powerbi.com/t5/Desktop/Change-of-data-source-from-excel-to-sharepoint/td-p/515417

https://community.powerbi.com/t5/Desktop/Change-excel-datasource-to-Web-sharepoint-file/td-p/330296

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!