Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
Is there any option to not get hidden columns in excel?
I have 100 columns such a lot but only 10 columns in use so I want to get only 10 of them.
* the columns orders or format is chaning often so can't expect which columns would be hidden/unhidden every time so manual column selection in query won't help.
my previous question still unresolved.
Solved! Go to Solution.
Hello @jeongkim ,
you can use the choose columns in power query to only choose the columns you need.
check it out https://learn.microsoft.com/en-us/power-query/choose-remove-columns
Proud to be a Super User! | |
Hello @jeongkim ,
you can use the choose columns in power query to only choose the columns you need.
check it out https://learn.microsoft.com/en-us/power-query/choose-remove-columns
Proud to be a Super User! | |
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |