Forum Discussion
Will Power Bi / Query support multithreading in the future?
Power BI already uses multiple cores. If you want to splurge, get more memory.
HI nascaline,
As lbendlin said, current power bi already enabled multiple threads feature. (e.g. parallel loading)
You can direct use these features if your device existed enough resources. For performance reasons, I'd like to suggest you use the 64-bit version instead 32-bit version. (notice: 32-bit version has 4G limit on memory resource usage)
BTW, you can also take a look at the following blog about tips and tricks to improve power bi performance:
Optimization guide for Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
I get over 400 pages in my report, even if I stop all visualizations/updates I have very long load times when building the report.While that is an absurdly high number, it has nothing to do with your issue. Pages are not pre-rendered. They will only be rendered when the report user explicityl looks at them. The Performance Analyzer gives you all the details about that process .
The Query engine is actually two parts - the Formula engine which is single threaded, and the Storage engine which can be multithreaded. Your design of the report visuals and measures will decide the eventual core usage
Keep in mind that a lot of this is academic as you have no control over the engine (or cores) in the Power BI Service.
Biggest takeaway - reduce the number of visuals on your pages, and make them render fast by inspecting and optimizing their queries.
TY!
So it has to be my DAX formulas (or my DAX inside the SSAS model) -> Because the Formula engine is single threaded.
Which would make sense looking at my problem.
Thank you, this helps me a lot
I need to ask you one more thing.
Why is it that my PBI Desktop loads everything pretty fast at the beginning but after some time it gets slower and slower -> Until I reopen the report.How much space do you have dedicated for the caches? Might be worth cleaning them out and checking if that makes a difference.