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

Hi v-dineshya 
1. Gateway connection name is unique and those 2 uses seperate warehouse in the connection and only mapped to their related datasets.

2. For the fix of Gateway log I'm still working with MSFT.

3. the role assignment is already there, but I'll dauble check that again and thank you for suggestion on seeting the default warehouse. will try that.

4. the problem is it's happening intermitently. let say we have 24 api trigger refresh per day for the dataset and 1 or 2 of them are behaving like this and that also not in consecutive run. that's where our problem is if it was executing all the runs with the wrong warehouse we can definitely say there is something wrong with either gateway connection or dataset configuration but lets say 10 runs execute with WH_A and SVC_A then 1 in the middle is executing with WH_B and SVC_B then again next 2-3 runs are fine and aging in one of the run it exceutes with WH_B/SCV_B and after that it works fine again.

I'll try to test with that particular table now the in the gateway schedule and see the results.