Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I am working with commercial aviation statistics.
Goals / Desired Outcome
Situation
Complication
Question
See also attached screenshots.
Thank you in advance for your consideration.
Solved! Go to Solution.
FYI that you can also create empty tables with DAX too.
NewTable = {BLANK()}
Pat
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
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
FYI that you can also create empty tables with DAX too.
NewTable = {BLANK()}
Pat
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
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
Check out the July 2025 Power BI update to learn about new features.