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)).
  • Load empty tables.
    • Use tables as a parking area for all my measures.
      • Each table will house a category of measures
        • e.g. Passenger measures, air cargo measures, aircraft landings measures....

Situation

  • I successfully created an empty table, and loaded the table without any problem.
    • Table name is _Measures

Complication

  • A second attempt failed.
    • However I duplicated the first empty table.
      • Loaded the table successfully.
        • Table name is DoNotUse.
  • Addtional attempts fails.
    • Tried both creating new and duplicating table.
      • Error message is the same.
        • Table will load but it will not be enabled.
        • If I later enable the table, the table will be deleted from data model.

Question

  • Is there a way to create tables without columns?
  • The end in mind is to use the tables to organize my measures.

See also attached screenshots.

Thank you in advance for your consideration.

 

 

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

     

    NewTable = {BLANK()}

     

    Pat

     

7 Replies

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage

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

     

    NewTable = {BLANK()}

     

    Pat

     

    • DAXRichArd's avatar
      DAXRichArd
      Icon for Resolver I rankResolver I

      I tried from the DAX side the same as you show above EXCEPT I did not include the {   } brackets.

      I hold control when I hit the Enter key?

      Thx

    • DAXRichArd's avatar
      DAXRichArd
      Icon for Resolver I rankResolver I

      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

        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

  • Hi Team
    As I am also facing a similar issue when I try to load the table in Power BI Desktop, with the below error message:

    But if I see the same table in DB it is showing data there

    Can any one help me with this

  • 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