Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DAXRichArd
Resolver I
Resolver I

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.

DAXRichArd_0-1672406650031.jpeg

DAXRichArd_1-1672406656802.jpeg

DAXRichArd_2-1672406680599.jpeg

 

 

1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

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

 

NewTable = {BLANK()}

 

Pat

 

Microsoft Employee

View solution in original post

7 REPLIES 7
HuyTran
New Member

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

Syndicate_Admin
Administrator
Administrator

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

ppm1
Solution Sage
Solution Sage

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

 

NewTable = {BLANK()}

 

Pat

 

Microsoft Employee

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

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

Microsoft Employee

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors