Forum Discussion

mamsteroonie's avatar
mamsteroonie
Helper I
5 years ago
Solved

Security on a Power BI Dataset

I want to do something that seems simple but I can't figure it out.   I want to publish a report to a premium workspace that has over 700 users.  However, I only want about 10 of those users to see...
  • mamsteroonie's avatar
    mamsteroonie
    5 years ago

    Hi, thank you for your reply.  I looked at the article.  This does not manage VIEWER access to a report, it only manages whether they can build on it, analyze in excel, or see it as a data source in another dashboard.  What we were looking for was NO viewer access on a workspace where a user has viewer access for all of the rest of the reports.  We were able to finally come to a solution.

     

    Create a dummy role in row level security in power bi desktop.  So just click on any table, and any field and create a dummy role (with no dax or value equaling that field).  Then publish.  then go to security on the dataset and enter the names of the people that should see the report.