Forum Discussion

ttypical's avatar
ttypical
Frequent Visitor
1 year ago
Solved

Composite Model published to App - users without direct user permission?

Hello,

 

In a workspace we have a new report published to App, the app audience is the entire organization, therefore the users are not having access to the workspace (Workspace A) or the semantic models itself. 
The report is built in composite model, the direct query connection is a semantic model (just import mode) from an Workspace B.

The users getting an error when they try to look at the report via the App.
I've tried to look around and found the user needs Read permission to the semantic model in Workspace B, but I do not know the individual users or even a group for them, as it is for all organization.
Can I somehow achieve that the end users are able to see the report in app without direct access to the semantic model in the other workspace (And without access to any of the workspaces). 
I was thinking if maybe if I change the mapping of the cloud connection to something else. I also have an enterprise gateway option but I'm getting lost how to achieve this. 

  • ttypical's avatar
    ttypical
    1 year ago

    Unfortunately that option is not available on the semantic model dataset permission settings (neither workspace level). I've tried already but only users or groups are coming up, Everyone/Entire/All etc is not recorgnised.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ttypical 

    If such a group does not exist, you can contact the IT team to create a security group that includes the entire organization. If possible, move the reports and semantic models to the same workspace. When the dataset and reports are in the same workspace, users do not need separate permissions when accessing through the application.

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Hi ttypical 

    Grant Build permission to "Everyone" or "Entire Organization" on the semantic model dataset in Workspace B via Manage Permissions. This allows users to view the report without workspace access.

     

    Did I answer your question? Mark my post as a solution, this will help others!

    If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

    Kind Regards,
    Poojara
    Data Analyst | MSBI Developer | Power BI Consultant
    Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

    • ttypical's avatar
      ttypical
      Frequent Visitor

      Unfortunately that option is not available on the semantic model dataset permission settings (neither workspace level). I've tried already but only users or groups are coming up, Everyone/Entire/All etc is not recorgnised.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi ttypical 

        If such a group does not exist, you can contact the IT team to create a security group that includes the entire organization. If possible, move the reports and semantic models to the same workspace. When the dataset and reports are in the same workspace, users do not need separate permissions when accessing through the application.

         

         

         

         

         

         

        Best Regards,

        Jayleny

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.