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, it automatically adds any new columns that are created on the list. Is there a way to stop this from happening?
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
do i do this in a specific step?