Forum Discussion
Advocate VLive semantic model questions
Hi Peter_23
Giving a short yet detailed answer of your questions:
RLS in Report 2: Yes, RLS will work in Report 2 because it inherits the roles and rules from the original semantic model (Original SM).
DAX Limitations: Some DAX functions may not work in DirectQuery mode for calculated columns or RLS, but this applies to the original model. In Report 2 (live connection), you can't define new calculated columns or RLS; it relies on the Original SM.
App Integration: Yes, you can add Report 2 to an app without any issues as long as permissions and roles are properly configured.
Performance: Live connections depend on the Original SM's performance. If the Original SM struggles (e.g., complex DAX, large datasets), Report 2 will also face performance issues. Optimize the Original SM for best results.
Hope it helps you, and clears your doubt regarding the topics you mentioned.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Super UserHi Peter_23
Giving a short yet detailed answer of your questions:
RLS in Report 2: Yes, RLS will work in Report 2 because it inherits the roles and rules from the original semantic model (Original SM).
DAX Limitations: Some DAX functions may not work in DirectQuery mode for calculated columns or RLS, but this applies to the original model. In Report 2 (live connection), you can't define new calculated columns or RLS; it relies on the Original SM.
App Integration: Yes, you can add Report 2 to an app without any issues as long as permissions and roles are properly configured.
Performance: Live connections depend on the Original SM's performance. If the Original SM struggles (e.g., complex DAX, large datasets), Report 2 will also face performance issues. Optimize the Original SM for best results.
Hope it helps you, and clears your doubt regarding the topics you mentioned.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Peter_23Thanks Poojara_D12 very explained! 😀