Change Data Source in Power BI either through Service or Programmatically for Snowflake as a source

[smukherjee]

Hi,

I have been trying to create some reports and publishing them to Power BI Service. There are some issues I have faced when it comes to changing source settings for report sharing between environments like DEV/TEST/PROD.

1. Power BI service Issue

Let's say I have two workspaces DEV and TEST. If I try to create a pipeline and move the report and datasets from DEV to TEST, I can then go to the TEST workspace and change the data source settings in Power BI service to let my TEST data set point to TEST database.

The problem for snowflake is that they only allow to change the credentials and not the connection string as snowflake has multiple connection details like Warehouse Name, DB Name, Role Name etc that could change for the new environment.

The second issue is that we can't add deployment rules or parameters for Snowflake in the pipeline as well.

Question 1 - Does Power BI Service has any way of allowing us to change the inner details or is it really confined to just the credentials?

1. Power BI Desktop Issue

In desktop Snowflake as a source has these issues regarding data source change:

a. We don't get to use parameters as pre-saved DB details to be used during creating connections.

b. Even if we want to change the source string in the Data Source Settings it doesn't appear as shown below

Fix that I have found for the issue - We need to go the Advanced Editor tab inside Transformation. There we can change the details manually for each table selected. The process works but seems too much manual work to be useful when we have multiple tables in this situation.

Question 2 - Does anyone have any idea how to change the data source settings in Power BI Desktop for snowflake which can work universally for all the tables?

Question 3 - Can this be done programmatically by any other way before we deploy to TEST workspace?

[komalrawat]

Hi ,

I am facing the same issue, as I cannot create deployment rules for reports that are using Snowflake as the data source. Did you find any solution from MS? 

[v-robertq-msft · Accepted solution]

Hi,

@smukherjee 

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.

[andreaalvarez]

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