Power Query - Change source (from Excel to database)

[Anonymous]

Hi,

I am building a report based on an excel input file. 

Later, I would like to connect to a snowflake view, which has exactly the same columns as my excel file. 

Can you give me a tipp / best practice how to change the sources later dynamically in Power Query?

Thank you very much!

[Anonymous · Accepted solution]

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.