Forum Discussion

DAXRichArd's avatar
DAXRichArd
Icon for Resolver I rankResolver I
3 years ago
Solved

This query does not have any columns with the supported data types. It will be disabled from being..

Hello, I am working with commercial aviation statistics.   Goals / Desired Outcome Create empty tables in Power Query Editor. Remove table columns (column-less table (table without columns)). L...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    FYI that you can also create empty tables with DAX too. 

     

    NewTable = {BLANK()}

     

    Pat

     

HuyTran's avatar
HuyTran
New Member
1 year ago

Here is the solution

1. In Query Editor, temporarily remove step "Removed Column" of that table --> then Close & Apply 

2. In "Table View" tab, move any measure into this new table, make sure this table contains something.

3. Go to Query Editor again --> then you can add again step "Removed Column" --> then Close & Apply.

Now you would get a table without any column and wont get the message "This query does not have any columns with the supported data types." anymore