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

     

ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

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

 

NewTable = {BLANK()}

 

Pat

 

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

Tried it. My desire is not to have a column. I can do the same in query. However, I appreciate your thoughtfulness in your reply. Thx again.

DAXRichard

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Ok. Why are you trying to get rid of the column? Is it not enough to just choose "Hide in report view", so it doesn't show there?

     

    Pat

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

      Hello,

      Just a cleaner look.

      I created that one table in MQuery and was able to remove the column.

      Perplexed me when I could not do it again.

      This is not a show stopper for me.

      Was hoping someone could explain it all to me.

      I would say this this request is closed.

      Thanks for your reply and have a great New Year 2023!

      DAXRichard