Forum Discussion
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....
- Each table will house a category of measures
- Use tables as a parking area for all my 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.
- Loaded the table successfully.
- However I duplicated the first empty table.
- 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.
- Error message is the same.
- Tried both creating new and duplicating table.
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
Solution Sage
FYI that you can also create empty tables with DAX too.
NewTable = {BLANK()}
Pat
- DAXRichArd
Resolver 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
Resolver 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
Solution 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
- Syndicate_Admin
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
- HuyTranNew 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