Forum Discussion
How do I stop PowerQuery from adding new columns that are added at the source?
In my scenario, I have an excel file that uses PowerQuery to connect to a SharePoint List. I've removed all unwanted columns and won't need any new columns that are added to the List. On refresh...
You can click on the Choose Column button in the toolbar, or ctrl-click each of the desired columns, right click and choose Remove other columns. This will create a step to keep just the desired columns and any new columns will be automatically removed too.
Pat