Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power Bi composite model - users can't see visuals/data

Hi All

 

I have created a Power Bi composite model report and published into my Org. workspace.

The report works well for me but not for the people I shared it with.

The issue is that all visuals with data display the error you see in the screenshot attached.

I have read a couple of articles on here that mention Gateway and Data credential settings.

In my case the Gateway seems not to be needed:

 

With regards to the Data credential settings I have cheanged these to what you see below but it still doesn't fix the issue.

 

Can you please help? Anything I should do?

 

Need Help

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Yes, your users need to have access to your app/workspace AND to ALL apps/workspaces where the datasets reside that you included in your composite model.  Think of it as a crazy game of RLS where you can't say the name RLS.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for that, so to double check do end users need a "viewer" or must have a "contributer" permission level on all workspaces linked to the model to make it work?

      Is there any way of doing this without granting full access to the workspaces?

    • CLiden's avatar
      CLiden
      New Member
      3 years ago

      Just to be clear. Its not enough to give the user read access to all underlying datasets of a composite model report + access to the app which distributes this report? 

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Correct, that is necessary but not sufficient. They also need to "install" all upstream apps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Anonymous  ,

     

    Each user should have access to read from the underlying dataset. 

    For example if a user has access to a report but not the underlying dataset (Read permissions) the user will not be able to see the data.

    The same applies with composite models to ensure that the security is in place.

     

    Best Regards,

    Liu Yang

    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
    5 years ago

    Thanks All for the replies so far.

    As of Today after making sure all permissions are enabled (except that of Workspace admin) the end user still cannot view the report. I wish it was a lot "simpler" to share. ğŸ˜‘

    • rappleton's avatar
      rappleton
      Advocate II
      2 years ago

      Hi Anonymous did you ever get this resolved in the end, I am experiencing the same issue and have tried giving the users all access to everything and it still doesn't work for them. I have a ticket open with Microsoft for the past 4 months and they still cannot help. Any help much appreciated.