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.

delish68's avatar
delish68
Frequent Visitor
2 years ago

There isn't a semantic model explicitly/intentionally being created on top of it. I'm only guessing that it's being created because the report has some custom columns or measures in it. The intention is for the report to sit directly on top of the semantic model with RLS. Is there a way to resolve this?

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

You can build a new report with live connection to your dataset

 

  • delish68's avatar
    delish68
    Frequent Visitor
    2 years ago

    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).

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

      Sorry, you need to create it in the service

       

      • delish68's avatar
        delish68
        Frequent Visitor
        2 years ago

        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?