Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I imported an excel sheet with many columns
it's easy to select the columns i want in Report view, but in Query Editor it shows all of them. how can they be in sync so whatever columns i see in Report view is also in Query Editor?
Thanks in advance
Solved! Go to Solution.
Hi @Ehab,
1. If you want to delete some columns, you can also do it in the Data or Report pane.
2. There is a view of all the columns in the Query Editor.
Best Regards!
Dale
Thanks guys. i was hoping for a bird's eye view like in the report view with checkboxes of all the columns - as i said, if it's 30+ columns, the scrolling and deleting one-by-one (even with SHIFT & CTRL shortcuts to delete in groups) is cumbersome ... but sounds like it doesn't exist.
Appreciate the prompt responses.
Hi @Ehab,
1. If you want to delete some columns, you can also do it in the Data or Report pane.
2. There is a view of all the columns in the Query Editor.
Best Regards!
Dale
Thanks for this!
and thank you everybody
Hi @Ehab,
1. When you enter the query editor just select the column you want to delete (like in my picture below)
2. You can also select all columns you want to keep and press remove other columns (you can select multiple by holding CTRL)
When you delete it in query editor it will also be deleted from the report view.
Regards,
L.Meijdam
thanks,
i was just wondering if there was an easy view as in the report menu shown below ... when you have 30+ columns and you only want a handful, the approach you mention is very time consuming (apologies on the screen shot ... blocked out much of it below for confidentiality reasons ... there are 30+ fields ... being able to scroll quickly and check the ones i want is very convenient
I dont know if you know this already so I thought i would just put it out there but next to <Remove Columns> there is <Choose Columns> which provides an easy view for you to select which columns you would like to keep
Another way to remove multiple columns is to use the editor.
First delete a column. In the equation box find the name of previous step in the string. In the case below the previous step was #"Sorted Rows"
= Table.RemoveColumns(#"Sorted Rows",{"PF-3_MS-3_16"})
Now replace the entire string with the one below using the name of your previous step. Replace the leading characters of the row/s you want deleted with the "PC" below and/or replace "search" with your search string that you want to find. This will remove all columns containing your designated characters.
= let columnsToRemove = List.Select(Table.ColumnNames(#"Sorted Rows"),each Text.StartsWith(_,"PC")or Text.Contains(_, "search")) in Table.RemoveColumns(#"Sorted Rows", columnsToRemove)
I don't know if you still need to know a way to easily select the columns you want but next to <Remove Columns> there is <Choose Columns> which allows you to selct the columns you would like to keep shown in a list format
You can also hold down Shift or maybe Ctrl key to select the columns you want and then right click and remove other columns.
Hi @Ehab,
On the query editor if you do CTRL + click on the columns you want and the DELETE on the keyboard it will do all columns at once.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsIn Query Editor, right-click the columns that you do not want and remove them.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |