Forum Discussion
Advocate IIIUsers unable to see DirectQuery data from composite model (have data access)
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:
They need build permissions for all datasets.
Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft DocsUsers 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.
5 Replies
- edhans
Community Champion
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
They need build permissions for all datasets.
Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft DocsUsers 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.
