Forum Discussion

music43's avatar
music43
Advocate II
5 years ago
Solved

Composite Model - Permissions issue?

Hi    I have created the following: Security Group call PBI - Dev which contains a single test user account with a Pro licence.   When logged into as my test user, most of the visuals show...
Need Help
  • music43's avatar
    music43
    5 years ago

    For completeness and in case anyone else finds this of use, I thought I would post the solution.

     

    I ended up opening a support ticket with Microsoft and after a series of communications and they collected various logs from the browser and gateway, we found the problem.

     

    There seems to be various layers of permissions (the container and the object).

    I had the workspace permssions set to viewer, which was correct.

    What I needed, was to modify the permissions for the dataset in the workspace.

    Adding build.

     

    For my audience needs, after unchecking these boxes in the app permissions it meant they could access the app content correctly but not have any access to the underlying datasets etc.

     

     

GilbertQ's avatar
GilbertQ
Super User
5 years ago

Hi music43 

 

You need to authenticate the AnalysisServices connection under data sources in your settings further down as shown below.

 

 

  • music43's avatar
    music43
    Advocate II
    5 years ago

    Hi GilbertQ 

     

    This is the first time I have done this so I maybe missing something.

    I see this:

    and when I click Edit Credentials I am prompted with this

    The drop down allows Basic or OAuth2. The Learn more takes me to this link which shows a slightly different dialog box.

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect#single-sign-on

    When I have entered my credentials it returns me to the page and the original message remains unchanged but I get this confirmation (top right of the page)

    Immediately after trying this I refreshed my other browser logged it with my test user and the issue persists.

    If I try adding the dataset to the gateway which suggests is 'optional', I get an error

    This feels like it should be a simple fix. Any guidance is MUCH APPRECIATED.

     

    Thanks again

    PS I enjoyed your virtual session at the Power BI Summit this year.