Forum Discussion
DirectQuery for Power BI Datasets issue when sharing report
Hi Powerbi Community,
We enabled the feature in our tenant to use direct query for powerbi dataset. The feature has been activated for our dev team so they can build dataset using other dataset from premium workspace and share the report to the organization. (link to the feature's doc : https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services)
The feature works as inttended for the dev team, but when testing with users it is not working for them (even though they are member of the workspace).
The report opens for them but visuals fail to render :
Do we need to activate the feature for whole organization so they can open the report only?
Thank you!
6 Replies
If your users have the member role on the workspace where all the datasets reside, then I believe I am at a loss here. I will do some testing as we have the same scenario that will soon come to play.
What I think is that maybe the setting for DirectQuery to powrbi dataset has to be activated for report consumer as well. But we do not want to open this feature too wide in the organization.
I believe your report consumers will need read permissions all datasets in the chain. If any dataset is in a Pro workspace, then it looks like they will also need build permissions on it. Interested in your result.
From your picture, if you click on the "See details", what is the error message displayed?
Here is the screenshot, not much help there I think 🙂
