Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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 :


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!

Memorable Member
Memorable Member

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.

Memorable Member
Memorable Member

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 🙂



Memorable Member
Memorable Member

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.


Hi @blopez11 all dataset and report are in the same premium workspace and users that are testing are member of the same workspace (so they have all permissions on all dataset)


However it is not working for them so far

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors