Forum Discussion

JoFonseca's avatar
JoFonseca
New Member
1 year ago
Solved

Permissions for report using several semantic models

Hi, I'm creating a summary report that uses several semantic models from different workspaces, using Direct Query. The issue is that most users cannot see visuals that are not part of the workspace ...
  • JoFonseca's avatar
    1 year ago

    The solution was to provide user access to the semantic models using the option Direct Access and unticking all the checkboxes, ensuring only read access (no build, reshare, etc). I had to use an AD Group to ensure access to all users in my organization. Additionally, using the option OneLake, I asked some users to check if they could see the semantic models for which access was given and the option "Explore data" was deactivated, meaning they can only see the data I display in my report and nothing else (given that some details are confidential). I didn't had to provide any permission in the different workspaces, so the users cannot access any team specific workspaces or reports.