Forum Discussion
Power Query - Change source (from Excel to database)
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!
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.
1 Reply
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.