Forum Discussion
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/
- Anonymous4 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
- AnonymousNot 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.
- mh2587
Super User
I think a relationship issue between calendar and payroll earning
- AnonymousNot applicable
Hi Anonymous ,
What is the relationship between these tables?
You may consider to change it from "single" to "both".
Best Regards,
Jay