cannot load data from combined datasets over directquery (only some users affected)

[siouxme]

Hi

We have a shared dataset 1, used from another PBIX (=dataset 2).

both a published into different workspaces.

Dataset 2 uses queries from dataset 1 over "PowerBI Dataset" online as Directquery. Also other datasources are there in dataset2.

When I see the report of dataset2 all pages work correctly. When some of my colleagous are viewing the report dataset2, the have with a single page problems, all other work as expected.

The page that does not work for them is related to a DirectQuery pointing to dataset 1.

Note also, that the model in dataset 2 has relations between dataset1 tables and this table coming from dataset 1 as directquery.

The error msg is: "Could not load the data for this vizual, please try later. see details"

The detail is:

Couldn't load the data for this visual

Couldn't retrieve the data for this visual. Please try again later.

Please try again later or contact support. If you contact support, please provide these details.

Hide details

• Activity ID713bd9c8-8aec-4e60-aa9d-cfb9c7bca769
• Request ID3d35500c-6c12-6092-c3ec-0dc1c8118066
• Correlation ID53edea1f-7756-4f63-281b-355d09931079
• TimeTue Jun 14 2022 16:43:13 GMT+0200 (Central European Summer Time)
• Service version13.0.18442.44
• Client version2206.1.11664-train
• Cluster URIhttps://wabi-north-europe-h-primary-redirect.analysis.windows.net/

At least from one user I know, that he has the free license.

Where should search and for what to resolve this issue?
BR

[v-yingjl]

Could not reproduce it in my side as far as my test. When I tried to create the two datasets and used other accouts to access the report under Direct Query, the visual loaded data normally.

Perhaps you can try to check that whether these users who cannot see the visual data have the right access to dataset1 in Power BI Service first. 

Best Regards,
Community Support Team _ Yingjie Li

[siouxme]

Yes, you were right. It was a simple problem with the rights. When using Directquery from one dataset to another, every user needs not only VIEW but also BUILD rights.

https://docs.microsoft.com/de-at/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

[v-yingjl]

Thanks for you confirming and gald to hear that it could be solved by the access..

Best Regards,
Community Support Team _ Yingjie Li