Forum Discussion
Change Data Source in Power BI either through Service or Programmatically for Snowflake as a source
Hi,
As far as I’m concerned, one table stands for one query in the Power Query editor, so you have to change the data source in the advanced editor one by one. The only way to change the data source settings in Power BI Desktop for all the tables is going to the “Change Source” option of the “data source setting”, but it’s greyed out in your sample picture.
You can refer to these links and find if they can be helpful:
https://docs.snowflake.com/en/user-guide/data-pipelines-intro.html
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-snowflake
https://community.powerbi.com/t5/Desktop/Change-data-source-for-all-tables/td-p/710273
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi,
As far as I’m concerned, one table stands for one query in the Power Query editor, so you have to change the data source in the advanced editor one by one. The only way to change the data source settings in Power BI Desktop for all the tables is going to the “Change Source” option of the “data source setting”, but it’s greyed out in your sample picture.
You can refer to these links and find if they can be helpful:
https://docs.snowflake.com/en/user-guide/data-pipelines-intro.html
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-snowflake
https://community.powerbi.com/t5/Desktop/Change-data-source-for-all-tables/td-p/710273
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @smukherjee
I'm working with Snowflake and pipelines in Power BI. Did you find any solution?
Really appreciate if you could share the solution with me.
Thanks!
Regards,Andrea