Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |