Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Couldn't Load the data for this visual.

Not loading my report, and listing the below reason:

 

The expression referenced a relationship between '<pii>Payroll Earnings</pii>'[<pii>Date Week Ending Worked</pii>] and '<pii>Calendar</pii>'[<pii>Date</pii>], which does not hold any data because it needs to be recalculated.

 

Activity ID: e0925245-8138-4d93-a9a4-aca3fa8d5463
Request ID: 2b43f06b-924b-4fae-8e90-3840aaa211e9
Correlation ID: f7ce5ace-f940-5249-20a1-4a2916aa6c95
Time: Tue Jul 19 2022 08:11:57 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.18666.32
Client version: 2207.2.12226-train
Cluster URI: https://wabi-us-north-central-e-primary-redirect.analysis.windows.net/

  • Anonymous's avatar
    Anonymous
    4 years ago

    Thank you mh2587 and Anonymous  for your input, but this has cleared up on its own.  It must have been a software/internal issue.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you mh2587 and Anonymous  for your input, but this has cleared up on its own.  It must have been a software/internal issue.

  • I think a relationship issue between calendar and payroll earning

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    What is the relationship between these tables?

    You may consider to change it from "single" to "both".

     

    Best Regards,

    Jay