Forum Discussion
Not able to select multiple columns in power query
Hi KR300
You can select multiple columns by holding the CTRL key on the keyboard and selecting the column you need or using the choose column features in Power Query.
Note: the green box is selected columns using CTRL key, the red box is unselected column.
If you find this helpful, kindly mark my response as a solution.
Regards,
Mubar
Hi KR300,
Thank you for reaching out to Microsoft Fabric Community.
As suggested by below super users can you please explain your issue in detail, so that we can provide you the best possible solution.
Thanks and regards,
Anjan Kumar Chippa
i have the same issue on my power query. if i select 1 column, hold down the Ctrl key or the ctrl+shift keys then try to select another column the first column i selected gets unselected and it selects only the second one. so ultimately i cant select more than 1 column at a time.
I have tried using the selct function which works when reducing removing some columns but when i am trying to Pivot or Unpivot i seem to not have a solution that works