Forum Discussion

julienvdc's avatar
julienvdc
Icon for Helper III rankHelper III
2 years ago

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

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???

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      julienvdc
      Icon for Helper III rankHelper III
      2 years ago

      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...