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?
- jeroenterheerdt
I 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).
