cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smukherjee
Frequent Visitor

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

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.

smukherjee_0-1619619389777.png

 

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

smukherjee_1-1619619406654.png

 

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

smukherjee_2-1619619429656.png

 

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?

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-robertq-msft
Community Support
Community Support

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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!