Forum Discussion
RLS Not Working with "Intermediary" Model
I got to the bottom of this. At some point, one of the developers enabled DirectQuery, which creates this "intermediary" semantic model. I don't think there's a way to remove that so we are copying and pasting everything from the original report to the new report.
That's exactly what we did. However, when we publish the report, we end up with an additional semantic model with the same name as the report (which points to the live Power BI dataset).
Community ChampionSorry, you need to create it in the service
It's a complex report that's already been created. Having to create it in the service seems like an odd requirement. I think the important question is, why is this additional semantic model (Expense Report model) being created when my report is built on the "Financial Model" model?
- aj1973
Because you have created it when using Get Data in power bi desktop.
The main purpose for that action is when a developper creates a big Dataset or, Dataflows or Datamart to be reused by other users without editing the master one for security reasons.
I have created other reports in Power BI desktop, based on the Financial Model (using Get Data), and it does not have the same behavior of creating an additional model when publishing.