Forum Discussion
Zooming In and Out in Power Query Editor
I am working on a very large table, so I would like to zoom out in Power Query Editor in order to quickly delete numerous columns. Is it possible to zoom in and out in the power query editor?
Hi,
I think there is no such function in Query Editor, but i have a workaround.
You can use 'Choose Columns' function:
Select the columns you want to keep:
After choosing columns, the result shows:
Hope this helps.
Best Regards.
Giotto Zhi
6 Replies
- TurwinNew Member
Old post, but there is a way to zoom in the power query editor:
Zoom in: "CTRL" + "SHIFT" + "="
Zoom out: "CTRL" + "SHIFT" + "-"
Works in Excel and Power BI. - amitchandakSuper User
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.- palemiRegular Visitor
I am referring to decreasing the magnification (the zoom) in the power query window in order to grab more columns at a time. I have a very wide table, so selecting columns manually takes time. The more I zoom out, the easier it is to use Shift to grab multiple columns.
- v-gizhi-msftCommunity Support
Hi,
I think there is no such function in Query Editor, but i have a workaround.
You can use 'Choose Columns' function:
Select the columns you want to keep:
After choosing columns, the result shows:
Hope this helps.
Best Regards.
Giotto Zhi
- v-gizhi-msftCommunity Support
Hi,
You can easily delete columns in Query Editor:
And i advise you using 'DirectQuery' connection mode to get the data.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#when-is-directquery-useful
Best Regards,
Giotto Zhi