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

     

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