Forum Discussion
Missing data from Fulcrum
Hi, thanks in advance for any help!
I’m working on two dashboards that pull different data from the same Fulcrum table. One field that’s in both is quantity, and for some reason, some records are being pulled in with the correct quantity in one dashboard and a blank quantity in the other, even when refreshed at the same time.
I’ve confirmed that it’s a Power BI issue and not a Fulcrum issue by using the query utility and checking the record IDs against the data in the dashboard with the blanks. No filters are applied to the visualizations, so that doesn’t seem to be the issue. The data types are the same in both dashboards. The only difference seems to be which other fields are being pulled in alongside quantity.
Has anyone seen this before? Any ideas what could be causing the issue or what I could do to fix it? I would prefer an automated fix over a manual override as I won't always be the one managing this dashboard and don't want to overcomplicate things.
2 Replies
v-xicaiCommunity Support
Hi Anonymous ,
You may click "go to report" option for the two dashboard to get the unpinned original visuals, then you can click "show data" option in upper right corner of related visual to compare original data of the two visual, there may be some aggregation calculations for fields of in the original visuals.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.