Forum Discussion

ysapiyev's avatar
ysapiyev
Responsive Resident
8 years ago
Solved

Slow performance on PBI report server

Hi everyone,

 

I have a resporting service installed on server, And Power BI report has very slow performance. I use SSAS connected to report. I already reduced SSAS cube for better performance. Also, server has intel xeon 1.8 GHz and 64 GB RAM. What can be done, to increase its performance?

 

update:

 

Also, how to determine optimal and pick values required for Power BI report server functionality? Currently, it uses ~50% of CPU and 4-6 GB of RAM in MOLAP mode. If I change to ROLAP, usage of CPU increases to ~70%. So, what cube would be optimal and server configuration as well?

 

 

Regards,

Yerkhan

Need Help
  • MauriceMecowe's avatar
    MauriceMecowe
    8 years ago

    ysapiyev no you won't see the Power BI file (only with import), but you can directly execute the same query's as Power BI would against the tabular model and review the performance.

6 Replies

  • MauriceMecowe's avatar
    MauriceMecowe
    Resolver II
    8 years ago

    Hi ysapiyev have a look in DAX studio, to see how the DAX in your PBI reports perform, you might be able to optimize the DAX and get better performance. Otherwise maybe upgrading the hardware might be helpful.

    • ysapiyev's avatar
      ysapiyev
      Responsive Resident
      8 years ago

      MauriceMecowe,

       

      Thanks for your answer. Can DAX studio trace with live connection? I tried connecting to my report, but it didn't recognize it,

       

      Regards,

      Yerkhan

      • MauriceMecowe's avatar
        MauriceMecowe
        Resolver II
        8 years ago

        ysapiyev

         

        If you connect to the Tabular/SSAS instance via live connection with Power BI Desktop, you should also connect your DAX studio with your Tabular/SSAS instance.

        Only when you use the import function can you use DAX studio directly with Power BI Desktop.