Forum Discussion
Adding Data Points to a Table or Chart After Power Query Refresh
I have an Excel workbook that has a worksheet for calculating who doesn't have access to our system based on content on the site. These calculations use XLOOKUP to compare two other workbooks (1 CSV ...
Confirm that your Power Queries for both the CSV and XLSX files are set up correctly. Make sure that they effectively transform the data into a format suitable for your calculations.