Power Query - Change source (from Excel to database)

Hi Anonymous ,

Create a new PBIX file that connects to the Snowflake Data Source. Open the Advanced Editor in Power Query and copy the Source and Navigation rows. Now open the copy of the report connected to Excel. Open an advanced editor and replace the Source and Navigation rows with the copied Source and Navigation rows.

If you want to dynamically change the parameters that can be used by the data source, refer to

How To Change Data Source Of Existing Report In Power BI (c-sharpcorner.com)

Change the Data Source dynamically in Power BI using Parameters - SqlSkull

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD

How to change source data location in Power Query (7 ways) (exceloffthegrid.com)

Best Regards,

Neeko Tang

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