Forum Discussion
Direct Query with Snowflake sequential handling of queries
This article by SQLBI actually describes this issue.
The Formula engine does not support parallelism and will send the queries sequentially. I am not sure why this is the case, though but at least I can start to focus on other problems since this is really dax motor-behaviour.
https://www.sqlbi.com/articles/formula-engine-and-storage-engine-in-dax/
Because the formula engine is single-threaded, any operation executed in the formula engine uses just one thread and one core, no matter how many cores are available. The formula engine sends requests to the storage engine sequentially, one query at a time. A certain degree of parallelism is available only within each request to the storage engine, which has a different architecture and can take advantage of the multiple cores available.
Hi Anonymous ,
Regardless of the improvements, the performance of the data source should always be the primary consideration when using DirectQuery. If the data source is slow, using DirectQuery on that data source will still not be feasible.
'Horizontal Fusion' is a great feature, according to the blog, you need to enable preview on desktop and republish to service for it to work, did you do that? If it still doesn't work, it is recommended to comment below the blog to ask PM if the feature supports Snowflake data source. Finally, it's a preview feature, and I recommend that users consider using the preview feature carefully in a production environment.
Behavior:
Premium capacity enables query caching to speed up report opening:
Query caching in Power BI Premium
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi Gao Anonymous ,
Thanks for you reaction, however this is unfortunately not the answer I was looking for.1. Regardless of whether the data source is fast or slow, I would want to know if there is a way to parrellize the handling of queries by the Power BI engine, because according to the microsoft docs that I refer to above, changing the settings as I did should help.
2. I did change the preview setting to have HorizontalFusion, and published it to a premium workspace, but no luck so far.
3. Regarding query caching, this is only valid for import datasets. My question is about DirectQuery mode.
I am interested to know if this feature supports Snowflake. How do I notify the PM about this thread?
Regards,
Remo