Performance Issues - RLS - Desktop to Embedded

[debenaire]

Hi

We have Power BI embedded. We have been updating our RLS to use DAX as opposed to relying on bidirectional relationships etc in our model to increase perofrmace. We tested this in desktop through Perofrmance Analyser which has made a great difference. However, when the report is published to service and accessed through embedded, perfomance is particualrly poor and seems worse than before the improvements! Any thoughts on why this owuld be and are there any services that allow monitoring of embedded performance to try and diagnose why this could be? Thanks in advance.

[v-rongtiep-msft]

Hi @debenaire ,

There could be several reasons for this, such as:

The capacity of your Power BI embedded service is not sufficient to handle the workload and concurrency of your users. You may need to scale up your capacity or adjust the workload settings to allocate more resources to the Power BI embedded workload.
The RLS rules that you are using in DAX are too complex or inefficient, and they are causing long query execution times or high memory consumption. You may need to simplify or optimize your RLS rules, or use other techniques such as static row-level security or dynamic membership.
The network latency between your Power BI embedded service and your data source is too high, and it is affecting the query performance. You may need to use a data gateway to connect to your data source, or use a data source that is closer to your Power BI embedded service.

Best practices for faster performance in Power BI embedded analytics - Power BI | Microsoft Learn

Optimization guide for Power BI - Power BI | Microsoft Learn

To monitor and diagnose the performance of your Power BI embedded service, you can use the following tools and methods:
The Power BI Embedded analytics tool, which is a web application that allows you to track and analyze the performance and usage of your Power BI embedded service. You can see metrics such as average load time, average render time, average query duration, and more.
The Performance Analyzer in Power BI Desktop, which is a feature that allows you to measure the performance of your report visuals and queries. You can export the performance data to a JSON file and analyze it in Power BI Desktop or other tools.
The Query Diagnostics in Power BI Desktop, which is a feature that allows you to collect detailed information about the queries that are sent to your data source. You can see metrics such as query start time, query end time, query duration, and more.

Power BI embedded analytics overview - Power BI | Microsoft Learn

Frequently asked questions about Power BI embedded analytics - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[debenaire]

Thank you for your reply. When you reference allocating more resource to embedded, what do you mean by this? We tested the dax in power bi desktop and the query times were drastically reduced. Capacity has been an issue but we now autoscale so can't see this as an issue. Thank you.

[v-rongtiep-msft]

Hi @debenaire ,

Organizations with Power BI Premium capacity or Power BI Embedded capacity can take advantage of query caching to speed up reports associated with a semantic model.

Best practices for faster performance in Power BI embedded analytics - Power BI | Microsoft Learn

Query caching in Power BI Premium - Power BI | Microsoft Learn

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.