Forum Discussion
Advocate IUnexpected Data Refresh Failure and Query Execution from Wrong Snowflake Warehouse in Power BI
Advocate IWe have multiple queries triggred from the report but I have seen issue with one particular table.
Yes in the Query we are specifying the Wharehouse/Role/ SCHEMA/ Databse everything explicitely. the Connection is going through a gateway, so we have configured the gateway connection with SVC User. bt iterestingly when we went to check in the Snowflake Query history I can see in the Query details it was executed under a diffrerent warehouse and a different service user, as the service user does not have the right permision so we got masked data nd the failure, otherwise there was no way to tell that this happened, also I refrenced the activity ID from the Snowflake Query tag to the gateway activity ID and call it's the same Query that was triggerd from the same report. and too bads for me that I can not see the Query from the gateway logs asI have another issue with gateway log file 😑
- tayloramy
Super User
Hi 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.- sushovan93
tayloramy 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.
