I added a new column in Power Query Editor and I went back to Refresh the Dashboard tab in the Excel Workbook I created that shows the pivot charts and they are all blank now.
How do I fix this error without rebuilding all the pivot tables and pivot charts.