Forum Discussion

RashmitaR's avatar
RashmitaR
Icon for Helper IV rankHelper IV
9 years ago
Solved

RLS error even though no roles have been created

Hi, I have a tabular model in azure analysis services . Even though I have not defined any roles in the model when I am trying to share it with a colleague , he is unable to see the data and its displays you do not have the permission to view this report as the owner has applied row level security.Could some one please help me understand the reason for this. Thanks.
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi RashmitaR,

    It's weird. How did your share your dashboard to your colleague? Follow the steps here? If it is, please click share and check your colleague acess permission like the screenshot below.



    Best Regards,
    Angelia

5 Replies

  • dilumd's avatar
    dilumd
    Icon for Impactful Individual rankImpactful Individual
    9 years ago

    I think you have to go to privacy under general settings Power BI service and give access to that user.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi RashmitaR,

    You have no row level security in your SSAS database? You update the data from SSAS databased to Power BI desktop, then create report in desktop amd publish it to service, you also have not create any Row-level security (RLS)? Please confirm it. And click the dataset in Power BI service, if there is permission settings. Please share more details for further analysis.

    Best Regards,
    Angelia

    • RashmitaR's avatar
      RashmitaR
      Icon for Helper IV rankHelper IV
      9 years ago
      Hi v-huizhn-msft , I have a live connect to the data SSAS database to Power BI desktop, then I have created reports in desktop and publish it to service,I have not create any Row-level security (RLS) either in the tabular model or power BI desktop. Once I click the dataset in Power BI service, I cannot see any permission settings.
      • v-huizhn-msft's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi RashmitaR,

        It's weird. How did your share your dashboard to your colleague? Follow the steps here? If it is, please click share and check your colleague acess permission like the screenshot below.



        Best Regards,
        Angelia

  • cjstudioguy's avatar
    cjstudioguy
    Frequent Visitor
    5 years ago

    I am having the exact same issue, except I am the owner of the report.  All the users that this report & dataset has been shared with can view the report, just not me (and 1 other owner).  It was fine, then after I went into the datasets page and refreshed the dataset, I get the RLS error trying to view the report.  I can view the report fine locally, and I can re-publish.  This is the 2nd report I've had this issue with this week.  The last time I had to delete the report and dataset from PBI and republish, but then I had to reshare it and update any external links I have pointing to the report, so this solution is not ideal.