Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

How to track Performance Issues of RLS in Embedded

Brass Contributor

Hi,

 

We have Power BI embedded. We have been updating our RLS to use DAX, as opposed to relying on bi-directional relationships etc in our model to increase perofrmace.

The performance while using bi-directional as below

Excellove15_1-1700638694508.png

The RLS tables relationships for above performance is:

Excellove15_3-1700638835159.png

 

We tested this in desktop through Perofrmance Analyser which has made a great difference as shown below:

Excellove15_0-1700638643117.png

The modified RLS tables relationships for above performance is:

Excellove15_4-1700638873500.png

 

The dax we used for above relationship is as below:

Excellove15_2-1700638766741.png

 

 

However, when the report is published to service and accessed through embedded, performance is particularly poor and seems worse than before the improvements!

 

We read some articles from microsoft on below

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

But we don't how to implement it, 'loaded event' and 'rendered event'. Also, I couldn't  find any practical illustration/demo for above article.

 

Any thoughts on why this could be and are there any services that allow monitoring of embedded performance to try and diagnose why this could be?

 

PFA reports below and i have shared before and after modifications:

PR-419 - Data Coverage RLS Update_high performance.pbix

PR-419 - Data Coverage_Low performace.pbix

 

Thanks in advance!

@Sergei Baklan 

2 Replies
best response confirmed by Excellove15 (Brass Contributor)
Solution

@Excellove15 

Sorry, I have no practice with Power BI embedded.

Hi @Sergei Baklan 

 

Nop! many thanks for your quick response!:smile:

I will close this query! 

 

Thanks!

1 best response

Accepted Solutions
best response confirmed by Excellove15 (Brass Contributor)
Solution

@Excellove15 

Sorry, I have no practice with Power BI embedded.

View solution in original post