Users unable to see DirectQuery data from composite model (have data access)

[Kletzy]

Posted this in ideas but not sure if it goes here: I have a composite model running off imported queries together with DirectQuery off a shared model (see below): - users have access to both models and can see reports connected to the imported portion of the data in the composite model as well as reports connected to the shared model (Luna) directly - they however cannot see the visuals connected to the direct query tables in the composite model (screenshot and error below). I can see both correctly, though initally had the same issue which was somehow resolved - some users could see the data but now can no longer:

[edhans]

DirectQuery for Power BI datasets is still in preview and I do not think the Lineage views are fully baked.

Do your users have BUILD permissions on the report? They need it to access the DQ/AAS data currently. That will not be a requirement when composite models are Generally Available, but it is a current issue in the Preview period.

[Kletzy]

@edhans thank you for your reply - they dont have BUILD access at the moment - that could be the issue as you suggest. So they need build permission on both models or only the shared model being direct queried? I assume there would be data sensitivity issues as they would then see all data in the model not just the data shared in the reports? All reports are shared via apps.

[edhans · Accepted solution]

They need build permissions for all datasets.
Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs

Users need 'Build' permissions on all datasets in the chain to access a report that leverages this feature.

It is a reason many are not using it in production. This goes away for GA, but during preview, it is still a roadblock.

[Kletzy]

Any idea when this will be GA so the build permission can be removed please?

[edhans]

Hoping this year. Build permission requirements were removed for Premium. It is more technical to remove it for Pro, so that is taking longer. The Power BI blog though will be the place to monitor. One day we will wake up and they will post that all issues are resolved and the feature is GA. Power BI Blog—Updates and News | Microsoft Power BI