topic Re: Composite model view access in Report Server

Composite model view access

KeithCoxAuto — Fri, 13 Aug 2021 14:43:02 GMT

Hi,

I know there have been a lot of posts on this issue but I can't anything beyond the steps I've already taken for my specific scenario.

We have a published custom calendar dataset (1), a published CRM dataset (2) and a published internal sales system dataset (3)

The custom calendar dataset (1) is linked to the CRM dataset (2) to create a new dataset (4)

That new dataset (4) is combined with the internal sales system dataset (3) and some measures are created in a final composite model (5)

That final composite model (5) is used to create a report. That works fine in the desktop app and fine for me to view on the service. All the datasets are published to the same workspace.

But another user gets the message that the visualisation can't be displayed as they don't have access to the underlying dataset. It gives them an option to request build permissions on the dataset.

The user has read, reshare and build permissions for all 5 datasets (with read and reshare permissions for the actual report)

Anyone have any idea what could be the issue?

Re: Composite model view access

Greg_Deckler — Fri, 13 Aug 2021 14:48:47 GMT

@KeithCoxAuto You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Re: Composite model view access

v-henryk-mstf — Mon, 16 Aug 2021 06:13:30 GMT

Hi @KeithCoxAuto ,

For users’ problems, the build permission is for the dataset. Only when you grant users the "build" permission, they can build new content in the data set.

The following screenshot may be the problem he encountered:

Based on the above reasons, check whether the user has the appropriate permissions, and then try again. For more details, you can read related document. Build permission for shared datasets - Power BI | Microsoft Docs

Best Regards,
Henry

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

Re: Composite model view access

KeithCoxAuto — Mon, 16 Aug 2021 08:06:12 GMT

Hi Greg,

Thanks, I'll open a support ticket.

Re: Composite model view access

KeithCoxAuto — Mon, 16 Aug 2021 08:07:09 GMT

Hi,

As I said, "The user has read, reshare and build permissions for all 5 datasets" - that's what's puzzling me about it.

Thanks.

Re: Composite model view access

v-henryk-mstf — Mon, 16 Aug 2021 08:10:25 GMT

Hi @KeithCoxAuto ,

OK. I will also pay more attention to your ticket, hoping to solve the problem as soon as possible.

Best Regards,
Henry

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