Direct Query Is Slow

Hi UncleLewis 

DirectQuery can be inherently slow, especially when working with large datasets like 470M rows – every interaction triggers a live query to the source. To improve performance, consider:

1. Minimizing complex DAX logic – keep calculations in Snowflake when possible.

2. Avoiding expensive functions like DISTINCTCOUNT, FILTER, and nested CALCULATEs in visuals.

3. Disabling Auto Date/Time hierarchy – it creates hidden tables and overhead.

4. Using aggregate tables – pre-aggregate data in Snowflake and expose summarized tables to Power BI.

5. Reducing visuals per page – each one sends its own query.

6. Testing with Import mode to check how much the model complexity affects performance (for comparison).

Trying to replace a view with a dynamic table might help only marginally unless the underlying logic is simplified.

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.