Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi guys,
I just created New Table in my Power BI, which actually to hold all my measures. So through Modeling Tab, I click New Table, name it in formula bar the Enter.
On Fields list (or in my data model) the new table appeared with 1 column (empty) named "Column". I don't need this, as I want this new table to hold my exisiting measures. So I move one of my measure, go to Home Table and select this new table. The measure moved sucessfully, and now I want to delete that "Column". There is no option to DELETE under Report view or Design view. What I notice have is under Relationship, I can sleect that "Column", right click and select "Delete from data model". But this too not affect anything since the column still there.
Is there anyway I can delete this empty column ? cause I don't want to just hide it.
Thanks.
Solved! Go to Solution.
Hi Mariuz,
This is just what I need. Thank you very much for the helps.
Cheers,
Every table must have at least one column, so no you can’t delete the last column. You can hide it from view if you don’t want to see it.
Hi Matt,
Understand that, but I've put my measure to that table already. So the column is not the only fields in that table. If not mistaken it used to be able to delete before. By delete the column and leave only the measures, the icon for the table will change to measure icon, is it not like that ? (at least I tried that before one time)
Thanks,
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
106 | |
64 | |
60 |