DirectQuery or Import for Snowflake

Power BI
1

Hello,

We got Snowflake as our new datasource. On Day 1, I thought I should use DirectQuery but I am already running into limitations from the get go.

So bit of a general question:

  1. DirectQuery or Import for Snowflake?
  2. These limitations make DirectQuery not an attractive proposition. Any advice why should we use DirectQuery?

image
image1390Ă—420 38.3 KB

Thanks,
Ritesh

2

When the data size is less than 1 GB and the data is not changing frequently, it is highly advised to use the Import connection. Use DirectQuery only for “real-time” datasets or datasets with humongous amounts of data.

1 Like