Log In
Register
Home
March 21, 2023
Offline
Lets say I have an excel table with 100 columns and I load this into Power BI, however I only want to use 30 columns.
As the 100 column file is how the data is downloaded from our system I do not want to delete any unwanted columns here, this I will do in Query as the future files will include these columns.
After the file is loaded into query, I transform the data and remove the unwanted columns.
Now I discover the future downloaded files (source data) exclude the unwanted columns however it clearly doesn't match what was originally loaded into Power BI. 100 vs 30 columns.
How can I change the way Power BI/Power Query views the file as I want to now upload the new file now containing only 30 columns, not 100.
Thanks
Paul
Trusted Members
Moderators
November 1, 2018
Offline
It will depend on how you removed the other columns. If you removed them explicitly then you'll just need to edit the query to remove the step that got rid of them. If you used a Remove other columns approach, then you should be fine anyway as you'll just have a Table.SelectColumns step that only names the columns that still exist (assuming there was no previous type changing step).
March 21, 2023
Offline
I have looked in Advanced Editor in query and I selected the columns I wanted and "Removed Other Columns" so there isn't a step that I can see where I actually removed the columns that match those in the source file
March 21, 2023
Offline
I've had another look and there is Table.SelectColumns step (see attached)
Which step should I remove as the columns listed are the ones I wish to keep
1 Guest(s)
