topic Re: Slow performance on PBI report server in Report Server

Slow performance on PBI report server

ysapiyev — Tue, 17 Jul 2018 10:57:03 GMT

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

Re: Slow performance on PBI report server

MauriceMecowe — Tue, 17 Jul 2018 07:31:54 GMT

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.

Re: Slow performance on PBI report server

ysapiyev — Tue, 17 Jul 2018 10:31:09 GMT

@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

Re: Slow performance on PBI report server

MauriceMecowe — Tue, 17 Jul 2018 11:59:13 GMT

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

Re: Slow performance on PBI report server

ysapiyev — Tue, 17 Jul 2018 12:54:27 GMT

@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

Re: Slow performance on PBI report server

MauriceMecowe — Tue, 17 Jul 2018 13:15:58 GMT

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

Re: Slow performance on PBI report server

ysapiyev — Wed, 18 Jul 2018 05:04:24 GMT

@MauriceMecowe,

Thanks. It worked.

Regards,

Yerkhan