Forum Discussion

nascaline's avatar
nascaline
Frequent Visitor
5 years ago
Solved

Will Power Bi / Query support multithreading in the future?

As captioned, buying a new PC, wonder if I need a higher core count CPU for future updates. Many Thanks
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    Power BI already uses multiple cores.  If you want to splurge, get more memory.

  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Patho's avatar
Patho
Regular Visitor
2 years ago

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


  • Patho's avatar
    Patho
    Regular Visitor
    2 years ago

    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.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      How much space do you have dedicated for the caches?  Might be worth cleaning them out and checking if that makes a difference.