Unexpected Data Refresh Failure and Query Execution from Wrong Snowflake Warehouse in Power BI

Hi sushovan93, 

This is very facinating, and if it is behaving the way you describe, should not be possible..

How many Snowflake queries exist in the model? Is it just this one or are there multiple? 

Does the connection specify a warehouse to use, or is it relying on using the default warehouse for the user? 

Is the WHS_YYY_ETL warehouse one that you also have access to? Is there any chance that a refresh ran under the owner's credentials once instead of under the configured credentials? 

Could this possibly be an issue with version 2.0 of the snowflake connector that came out in July? Does that timeline line up with when this started? Can you try adding Implementation="1.0" to the connector and see what the behaviour is?
Source = Snowflake.Databases("contoso.snowflakecomputing.com", "CONTOSO_WH", [Implementation="1.0"])

I'm very curious to see what the problem is here and where exactly this bug is sitting, but if it is behaving the way you describe it is very much a bug, and it seems like a pretty large one at that. 

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.