Forum Discussion

MiquelPBI's avatar
MiquelPBI
Helper I
9 months ago
Solved

Executive Semantic Model

Thank you for taking time to read the situation, background, and problem we're trying to solve. I'm eager to hear suggestions before we move to creating tech debt and persist data in a database.    ...
Need Help
  • parry2k's avatar
    parry2k
    9 months ago

    MiquelPBI can you use option 2 (DAX Queries) using semantic link labs in a notebook to write data to a lakehouse and then create an exec semantic model from lakehouse tables? You can schedule the execution of the notebook and the refresh of the semantic model using a pipeline.

     

     

Praful_Potphode's avatar
Praful_Potphode
Super User
9 months ago

Hi MiquelPBI ,

you can go with composite models in PBI desktop, the only challenge we have there is OLS.when we combine multiple semantic models into one composite models, the RLS will be enforced from base model.however,OLS gets enforced when user tries to do drag drop from the table.so tables are visible to end user.

https://tabulareditor.com/blog/composite-models-in-power-bi-and-fabric 

 

to overcome this you can create two types of semantic model:

1. Executive Dashboard Semantic Model(reload all data,create light weighted semantic model,contains only columns used in reports creation)

2. Self Service BI Models(Separate Semantic Model for Business Users,contains all columns used by business for analysis).

THis strategy worked out well in certain cases.

 

Please give Kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful

Thanks and Regards,

Praful