Forum Discussion
Unexpected Snowflake Queries Sent From Power BI
frtcndkm , are you using bi-directional join with direct query ?
or for each step check if query folding is working or not - https://docs.microsoft.com/en-us/power-query/power-query-folding#determine-when-a-query-can-be-folded
amitchandak no, there is only one dimension table which is connected with one-to-many and one-directional filtering. And the thing is even if I only load one table in a new file, it still sends those queries first when it's connected with native query.
If I use below query, I don't have those queries however I would like to keep using native queries instead of this widget navigation.
let
Source = Snowflake.Databases(Server,WH),
DB = Source{[Name=DatabaseName,Kind="Database"]}[Data],
PUBLIC_Schema = DB{[Name="PUBLIC",Kind="Schema"]}[Data],
Table= PUBLIC_Schema{[Name="TableName",Kind="View"]}[Data]
in
Table