Hi,
I have a pivot table, which is showing an error 'Reference isn't valid' when I click on 'Refresh All'. The data behind the pivot table is pulling off a SQL database, into Power Query, and the output from Power Query is then being put into a Pivot Table.

Very annoying error!