Forum Discussion
Appended Data Showing in Query View Not In Report
you can try by select the All Payment Data query.Ensure all PayPal data rows are present after the append operation.If rows are missing, revisit the append settings and ensure both data sources are correctly included.
Columns from both sources must match exactly in name and data type. Mismatched column names or types can result in missing data.
Temporarily remove relationships involving All Payment Data.Create a table visual with All Payment Data fields to see if PayPal data appears. If it does, the issue is with relationships; if not, the issue is with the append process.
check these and let me know still issue exist please share pbix file by removing confidential data.
In producing a sanitised version to post on here, I've discovered the problem.
One of the steps within my "Transform Data" stage is that, based on a booking reference ID, Power BI tells me what site this transaction relates to (my [Location] field). The results from this definitely match on Paypal, Stripe and All Payment Data because both Paypal and Stripe return the correct data on a lookup to All Payment Data on [Location] field.
When I've manually typed fake locations in to the Excel document to create fake data (so no formula based on Booking ID needed) the report brings everything back so it must be something about this [Location] field which is throwing the report.
Obviously I can create a workaround of an Excel formula to work out the location prior to Power BI but I'd like to avoid this if possible. Is there an obvious reason I'm unaware of which would make the correct data show in the table stage but not pull through to the report due to this formula?
Hope that makes sense!