Forum Discussion
Using DirectQuery for Power BI datasets users are not able to view the data in the report
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!
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!