Composite Model - Permissions issue?

[music43]

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 this:

The only place I can think of there being an issue is here:

The red cross seems like a warning but the hyperlink say optional...

I have tried adding the user email as a viewer in case the group was a problem but that hasn't worked. Any help would be amazing as I am running out of things to try.

[GilbertQ]

Hi @music43 

If you are using the cloud data sources you should not need to add it to the gateway.

I would suggest delete the data sources, go into the dataset settings and see if you can configure it there?

Thanks for attending my session!

[music43 · Accepted solution]

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]

Hi @music43 

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

[music43]

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-connec...

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.