Forum Discussion

cdthomas1217's avatar
cdthomas1217
Copper Contributor
Feb 01, 2022

Error - The command " isn't supported

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?

  • Tim_Dickinson's avatar
    Tim_Dickinson
    Copper Contributor

    cdthomas1217 

    I feel your pain!

    I have run into this same thing a number of times and have yet to come up with a solution.  Did you ever find the issue?

     

    td

Resources