Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

RLS to Modeled Dataset in Power BI Service

Is there a way to save a modelled dataset (e.g. with transformations done through Query Editor) in Power BI Service with row level restrictions in the data imposed?

My goal is I want to have a single dataset in Power BI service where my report creators can connect to using Power BI Desktop but these report creators should have limited access to the dataset. For example, I want report creator #1 to use only the data with Branch Id = 1.

Thanks!

Need Help
Tutorial Requests

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    It seems impossible currently.

    When using RLS with app workspaces in Power BI, If you publish your Power BI Desktop report to an app workspace within the Power BI service, the roles will be applied to read-only members. You will need to indicate that members can only view Power BI content within the app workspace settings.

    But for anyone who could download a pbix copy from Power BI Service, he must have edit access to the report.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-juanli-msft,

      Thanks for clarifying this. Is there a known or possible workaround to what I'm trying to achieve? The end goal is just for the report creators to connect to a modeled/ transformed data in Power BI (without accessing the original source, for example, a SQL database) and still have restrictions in the data?

      What I'm thinking for a possible workaround (although the method is quite brute and might not be recommended) is

      • I can create a single pbix with all that transformations in it. Then parametrize branch Id to make the query dynamic.
      • Publish the pbix for each branch Id into different workspaces. 
      • This way, the members of the workspace who can only view the data for their branch can create a report by using Power BI Dataset in Get Data.

      The catch here though is, I have a lot of branches. Can you recommend other possible ways to address this? Many thanks!