Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |