Error - The command " isn't supported

%3CLINGO-SUB%20id%3D%22lingo-sub-3098812%22%20slang%3D%22en-US%22%3EError%20-%20The%20command%20%22%20isn't%20supported%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3098812%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20workbook%20that%20uses%20Power%20Query%20to%20pull%20data%20from%20a%20table%20in%20another%20tab%2C%20transform%20it%2C%20and%20then%20load%20it%20into%20a%20separate%20tab%20to%20be%20used%20as%20a%20report.%20Everything%20works%20perfectly%20until%20I%20make%20changes%20to%20the%20query.%20Once%20I%20make%20a%20change%20to%20the%20query%2C%20I%20get%20the%20error%20%22The%20command%20%22%20isn't%20supported%22%20whenever%20I%20try%20refreshing%20the%20data%20and%20the%20query%20shows%20that%20the%20download%20failed.%20The%20only%20solution%20I%20have%20been%20able%20to%20find%20is%20to%20copy%20the%20query%20and%20load%20it%20into%20another%20tab%2C%20but%20then%20I%20have%20to%20recreate%20all%20of%20my%20formatting%2C%20slicers%2C%20and%20formulas%20that%20I%20am%20using%20for%20totals%20that%20are%20outside%20of%20the%20table.%20Is%20there%20an%20easier%20way%20to%20correct%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3098812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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?

0 Replies