Slow performance on PBI report server

[ysapiyev]

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

[MauriceMecowe]

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]

@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]

@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.

[ysapiyev]

@MauriceMecowe

Thanks. I installed DAX studio 2.7.4, and there is only Tabular server, As a result, it can't see my Power BI Desktop. I've tried typing server name and name of my pbix file - no result. Should I install other version or am I doing something wrong?

Regards,

Yerkhan

[MauriceMecowe · Accepted solution]

@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.

[ysapiyev]

@MauriceMecowe,

Thanks. It worked.

Regards,

Yerkhan