Live semantic model questions

[Peter_23]

Hi amazing community!

I have a few questions about live semantic model.

I developed a full report and publish in the service (RLS working) import mode. (Original SM)

So I need a new report (Report 2) from source  as  original semantic model, so If I developed this report using live semantic model (Original SM)

I read  Documentation  but I  don't understand  in all.

the questions are:

1. Is RLS working from new report? e.g active roles in Original SM.

2.- Some DAX functions have this stament from documentation: This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. 

In the live semantic model the table are DirectQuery not Import (Original SM)

3.- Could be it integrated in APP (the new report 2) ?  No issues.

4.-Perfomance issues?

thanks in advance.

[Poojara_D12 · Accepted solution]

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 

[Peter_23]

Thanks @Poojara_D12  very explained! 😀