I had to update my query today to change the Excel tab name because they updated the file source and were now sending it as "Sheet1", so I updated my query "table" as "Sheet1$".

Learn these 10 essential Excel Power Query tips to take your spreadsheets and data analysis to the next level. If you do not know these ten ...