cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AS31
Frequent Visitor

Using DirectQuery for Power BI datasets users are not able to view the data in the report

Hello everyone,

I built one report which uses 3 different datasets from 2 different workspaces. But when I am trying to share this report with other users or users who are already in the workspace and trying to access this report it gives error on all the visuals.

AS31_0-1629362660708.png

Any idea what could be the issue. 
Users have access to all the individual reports.

1 ACCEPTED SOLUTION

Yes, this is what @ibarrau ment by giving access to the dataset.

For Shared dataset user has to have access on source dataset as well (App user/viewer), so you have to give your users access on the source datasets (3 datasets in 2 different workspace).

Please refer Consideration and Limitations Intro to datasets across workspaces - Power BI | Microsoft Docs

 

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

3 REPLIES 3
ibarrau
Super User
Super User

Hi. Three datasets, interesting. You should share those datasets with the users too (at least as viewer). It won't be enough with the report with direct query, they need to have permission against the data.

I hope that make sense


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

AS31
Frequent Visitor

Hi @ibarrau , Thank you for your reply but as I mentioned users do have access to those reports and buid permissions on the dataset. Still they are getting this error.

Another thing which I just tried and it worked is, if I gave this user access to the both workspaces then they are able to view the report i.e, no cross marks on the visuals. Which is for me starnge, since I gave access to the dataset to people it should also work. Any idea ?
Best,
Ashu

 

Yes, this is what @ibarrau ment by giving access to the dataset.

For Shared dataset user has to have access on source dataset as well (App user/viewer), so you have to give your users access on the source datasets (3 datasets in 2 different workspace).

Please refer Consideration and Limitations Intro to datasets across workspaces - Power BI | Microsoft Docs

 

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!