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 , have you managed to make any progress on this topic?
It is now possible for Power BI to generate some SQL queries in parallel in DirectQuery mode: https://blog.crossjoin.co.uk/2023/03/19/directquery-parallelisation-in-power-bi-some-examples/
