Visuals in composite model reports aren't loading until original reports for each model are opened

[julienvdc]

Hey I have a weird one for you today 🙂

I have a global report that is composed of data from multiple PBi datamodels. I am getting the data from all these DMs in DirectQuery.

The idea of this global report is to display KPIs from each of these report, and if users want to see more details they can go to the dedicated report.

It's been working fine, until recently, where now users who open this global report and 90% of the visuals are broken. Users have access to all the original reports so they should be able to view the data displayed in this global report.

I've seen that if they open the different reports and then refresh this global report, the data in the visuals suddenly shows.... 😶

Has anyone faced this issue before???

[julienvdc]

Could it be a memory issue?

[Tutu_in_YYC]

Are you able to see the error notification of the broken visuals?

There could be alot of reasons why visuals are broken,eg compute/access/missing data. If you click on of the error, you should be able to get more info, and start troubleshooting from there.

[julienvdc]

Hey , all visuals appear broken, if I click on "See details", this is what I get:

Activity ID: be7b3970-b04c-4a22-b102-627d30668d46
Request ID: 8b02a93b-5a88-429e-8986-2c9f350c60fc
Correlation ID: f4b016b4-7851-8a41-3a35-de0d9dbc1602
Time: Tue Jun 18 2024 20:15:28 GMT+0200 (Central European Summer Time)
Service version: 13.0.23515.58
Client version: 2406.2.19558-train
Cluster URI: https://wabi-north-europe-n-primary-redirect.analysis.windows.net/

Like I said in my original message, if now the user navigate to the dedicated pbi report (from where I use data for some of my visuals) and then refreshes this global report the data will show in the concerned visuals. I did not change anything in the permissions in the meantime. Then if, the user navigate to another report, again, data will show upon refresh.

It is as if the data needs to be loaded in the original DM report first...