Forum Discussion
Advocate IUnexpected Data Refresh Failure and Query Execution from Wrong Snowflake Warehouse in Power BI
Super UserHi sushovan93,
I am quite confused at this behaviour.
Let me make sure I understand correctly.
In Snowflake, you have two warehouses, let's call them WH_A and WH_B.
You also have two service users, SVC_A and SVC_B.
In Fabric, you have a data gateway with a snowflake connection set up. THis connection uses WH_A and SVC_A.
In Fabric, you are running a semantic model refresh using the gateway connection.
After this refresh runs, in Snowflake, you see that it was actually executed as SVC_B on WH_B.
THis is very puzzling.
For SVC_B and WH_B, do you have any connections on the gateway at all that use these credentials and warehouse?
If this helped, consider giving some kudos. If I answered your question or helped solve your problem, mark this post as the solution to help futute forum users find it.
Advocate Itayloramy yes that excatly what is happening.
and also I have connection with WH_B and SVC_B in the same gateway.
However Its very unlikely as the under the dataset I can see only one connection maaping that's for WH_A and aslo the user who configured the dataset does not have access to the other connection at all
- tayloramy
sushovan93
Hmm okay.... So the semantic model has to be for some reason using this other connection sometimes, that is the only way it would be abl eto get the credentials.I'm sure you've already done this, but can you tripple check the connection being used? I've never seen a gateway randomly switch the connection like this, it seems very strange.
Can you also verify the permissions on both connections just to be sure?
This is sounding a lot like a bug.
If this helped, consider giving some kudos. If I answered your question or helped solve your problem, mark this post as the solution to help futute forum users find it.- tayloramy
sushovan93 Here's an idea,
is the SVC_B connection the first one you made on the gateway?
If a dataset is bound to a gateway without specifying the data source ID, the bind can attach to the first matching data source on that gateway - which might be your WH_B/SVC_B entry. Microsoft calls this out in the REST API (Datasets – Bind To Gateway).
If this helped, consider giving some kudos. If I answered your question or helped solve your problem, mark this post as the solution to help futute forum users find it.