Forum Discussion
Use 2 Power BI Datasets in one Report
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
Community SupportHi , 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
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