Use 2 Power BI Datasets in one Report

[esc]

I've created a report with two datasets from two workspaces.

In Power BI Desktop I had to create a local modell and have activated the preview function "Use DirectQuery for Power BI-Datasets und Analysis Services" so in the desktop Version it is working.

When I publish it to the service, I see also the report which I've created.

My Problem is: the users I had grant the access to the report, they see only this.

Our Admin confirmed this setting is activated
Intro to datasets across workspaces - Power BI | Microsoft Learn

The Users have also (read) access to the source Datasets 

I don't know what i can do, that other user can see the report.

[v-yueyunzh-msft]

Hi , @esc 

Based on my research and understanding for the Power BI feature dq for dataset, Build permissions are required to view reports built using this feature when one or more datasets in the chain are in Pro workspaces. If the creator a report has left the company or their Build permissions has been revoked since they created the report, Build permissions will also be required on all datasets in the chain.

You can first follow this official document to check if you met this or other limitation first,

Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn

If all done, please expand the error detail to provide in the case chat in "Text" format, thanks in advance!

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[esc · Accepted solution]

Hi,
thank you for the necessary hint.
I've granted first all possible permissions in the source datasets and the combined dataset.
Then it worked. After this I've removed the permission one by one.

The necessary configuration is:
In all Sourcedataset the read and write permission is necessary (not the build permission)

For the combined dataset (local datamodell) it is enough to have read access

For the report from combined dataset it is also enough to have read permission.

So the missing link why it was not working, was the (read +) write permission on the source datasets

[lbendlin]

Are you on shared or premium capacity?  If on premium, are you sharing via the workspace or the app?  If via the app did you send the app links* to these users so they can "install" it?  Without that registration step they won't see the data.

* Yes, links.  Users need to "install" ALL apps that contain source datasets for your report.

[esc]

the combined dataset and the source datasets are in a pro Workspace

[lbendlin]

What is a Pro workspace? In a scenario where both workspaces are Premium it is sufficient to have build permissions to the published apps.

[esc]

I mean this workspace settings

[lbendlin]

That would be in a shared capacity, and your read/write observations are probably correct.