Hello,
I have a workbook that uses Power Query to pull data from a table in another tab, transform it, and then load it into a separate tab to be used as a report. Everything works perfectly until I make changes to the query. Once I make a change to the query, I get the error "The command " isn't supported" whenever I try refreshing the data and the query shows that the download failed. The only solution I have been able to find is to copy the query and load it into another tab, but then I have to recreate all of my formatting, slicers, and formulas that I am using for totals that are outside of the table. Is there an easier way to correct this problem?
