Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Advocate INot sure if this was covered, i tried reading through the 246 replies and couldn't really find it.
In our use case, we are finding this feature frustratingly useless:
- We have PBI Premium
- We Centralize several 'golden' datasets in a centralized workspace
- We build reports in separate - business facing - workspaces, that connect to the centralized datasets.
- We have a mix of report authors with build permissions on these datasets and everyone else in the company essentially has viewer access.
- We also have some external guest accounts that access reports that connect to these datasets.
When we build a power bi dataset that direct queries two other datasets, our workspace admins and workspace members can view the reports and everything works great. After that, our report authors (dataset build permissions) and viewers cannot view anything. Typically the error message we get is couldn't display the visual, sometimes we get an SSO Error (AWSL).
We've tried multiple solutions, but at the end of the day if viewers inside of PBI premium cannot access this seemingly game changing feature, it's of no use.
My question is, is it on the roadmap to correct this? Is there timing available?
Microsoft EmployeeI am not entirely sure what you are experiencing. Please open a support ticket so we can investigate.
- hornsjd
Will do. We've played with it a lot, the functionality works except for viewers essentially.
- jeroenterheerdt
at this moment, viewers need build permissions to view reports. we are actively working on changing that, but it is an artefact of how this feature was build (no pun intended).
- hornsjd
Ahh, ok. Do you have an ETA on when this feature may be updated? Or an active uservoice record that I could follow for updates?
Go into the PBI service and double check that you have enabled build on all datasets participating in the model. Go to the dataset in the service, click the 3 elipses --> Manage Permissions --> Direct Access --> 3 elipses next to viewer account --> Add Build. Permissions for user should be "Viewer, Build"
