Forum Discussion

delish68's avatar
delish68
Frequent Visitor
2 years ago
Solved

RLS Not Working with "Intermediary" Model

Apologies if this is confusing... I have a "core" semantic model called "Financial Model". It has RLS implemented within it. It works fine when tested within Power BI Desktop and also works with a v...
Need Help
  • delish68's avatar
    delish68
    2 years ago

    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.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

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.

delish68's avatar
delish68
Frequent Visitor
2 years ago

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.

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Not same behavior ! and after publishing you don't get a new Semantic model in the service !

    Sorry but It seems weird.