Forum Discussion
Remove Other Columns - problems
As part of a reporting solution, I get an extract of data from an IT system that contains about 50 columns - but I only need about 8 of them. This is a CSV file that is saved on SharePoint Online. Wh...
Hi Anonymous ,
You could remove this step in the query editor.
Hi Anonymous ,
You could remove this step in the query editor.
Is the position of these columns always the same? If they are you could remove the promote headers step from the query, then remove the first row and manually name the columns you want to keep in order to make sure that the column names do not change. You could also use the trick in this blog post https://datachant.com/2017/01/24/power-bi-pitfall-5/ so that the names of the columns you do not want to keep are not important.
Thank you. This has worked. By having the changed type step before the "remove other columns" step - there was a reference to all of the columns specific names which is what caused the problem.
