cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xpherion
Advocate II
Advocate II

Power BI report renders really slow for table or matrix in Power BI report server

Power BI report is connected to SSAS tabular cube in Power BI Report server (on-prem). This report renders really slow for table or matrix objects. Same report renders fine in Power BI Cloud service or Power BI desktop. Is there performance issue with Power BI Report server?

1 ACCEPTED SOLUTION

Thanks Jon for quick reply. We found the problem, it is due to Matrix visualization version. New version of Matrix visualization doesn't work on Power BI Report Server (June 2017 release). More info here

 

http://community.powerbi.com/t5/Report-Server/PBIDesktopRS-version-Matrix-drill-down/m-p/227807#M567

 

You can also vote for this idea

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20469499-updates-to-report-server...

 

View solution in original post

2 REPLIES 2
Jon-Heide
Microsoft
Microsoft

Hi Xpherion - there are no general performance issues known for this, so it could be something unique to your report or configuration. A place to start is to determine if the time spent is in data processing (in SSAS) or in the PBI Server. You can query the ExecutionLog3 view in the catalog database, and check the TimeDataRetrieval value for your report (just filter for ItemAction=QueryData). You can also look at tracing in the SSAS server for query time spent.

 

Alternately you can look at tips and tricks for how to tweak performance of your reports with resources such as this

http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques

 

Another option is to contact Microsoft Support who can work with you in detail on the performance issue.

 

 

 

Thanks Jon for quick reply. We found the problem, it is due to Matrix visualization version. New version of Matrix visualization doesn't work on Power BI Report Server (June 2017 release). More info here

 

http://community.powerbi.com/t5/Report-Server/PBIDesktopRS-version-Matrix-drill-down/m-p/227807#M567

 

You can also vote for this idea

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20469499-updates-to-report-server...

 

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.