Forum Discussion
Snowflake Warehouse Setup for Cloud Connections
Hi, we're using PowerBI Cloud Gateway to connect to our Snowflake instance, using a 'Service Account' user that we created in Snowflake and configured the dataset to use in PowerBI
This all works fine if the cloud connection is configured to use the same warehouse as the one used by the user creating the dataset in PowerBI Desktop.
However, what we wanted to do was use a different, larger, warehouse for published PowerBI Reports than what the analysts would usually have access to.
When we try to create the connection using a different warehouse, we then can't map the connection, as the 'lookup' is on server+warehouse rather than just the server.
Has anyone found a way to achieve the ability to use a different warehouse for published reports vs desktop development?
2 Replies
- edhans
Community Champion
Have you tried using deployment pipelines? The analyst could publish to DEV with their connection string. Then when you deploy to test, you can use rules to change the server and database it is connected to. See Create deployment rules for Fabric's Application lifecycle management (ALM) - Microsoft Fabric | Microsoft Learn
Thanks for the suggestion edhans .
I did a bit of reading on deployment pipelines, and if I'm not mistaken we have to be on a Capacity plan to leverage that, whereas we're on standard 'Pro' licenses.
