Forum Discussion
How to track Performance Issues of RLS in Embedded
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
The RLS tables relationships for above performance is:
We tested this in desktop through Perofrmance Analyser which has made a great difference as shown below:
The modified RLS tables relationships for above performance is:
The dax we used for above relationship is as below:
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
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-performance-best-practices#query-caching
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:
https://1drv.ms/u/s!AhUFhM5jR1jqjnBy6yqq1L-uJAr8?e=hKihu3
https://1drv.ms/u/s!AhUFhM5jR1jqjnG4DBp6iRUvVJPk?e=cocgLi
Thanks in advance!
Sorry, I have no practice with Power BI embedded.
2 Replies
- SergeiBaklanDiamond Contributor
Sorry, I have no practice with Power BI embedded.
- Excellove15Iron Contributor