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...
- Have a list of the columns to be retained someplace
- maybe in your Excel Workbook, as a named Range or Table.
- Or just refer to the column headers of the existing Table
- In your PQ code, refer to that list to decide which columns to be Selected
do i do this in a specific step?