Forum Discussion
Appended Data Showing in Query View Not In Report
I have two Excel spreadsheets as my data source - 'Paypal' data and 'Stripe' data. In Power BI, I've managed to append as new to create All Payment Data and, in this table, I can see all the data c...
I deleted the relationship between 'Stripe' and 'Paypal' to 'Sites Information' which appears to fix the issue, so now only 'All Payment Data' links to 'Sites Information'.
It has now broken the variable listed above which is returning an Error for all transactions.
I don't understand why because there is still the relationship between the All Payment Data table (where I want the field to be) and Sites Information (where I'm getting the data from). Apologies, analysis isn't my role (I just think it's useful) so I'm slow to catch on.