Forum Discussion
Quenril
2 years agoResolver I
Power BI not recognising additional column in csv source data
Hello, Please help. I've added a new column in my csv data source and Power BI isn't recognising it. In the Advanced Editor source file the number of columns isn't listed so I can't amend it there: ...
- 2 years ago
Hi,
Since you mention Advanced Editor, please try this in Power Query:
- click on the table you're interested in
- go to Advanced Editor
- in the "let" section, look for the Column=<number> argument
- replace <number> with <null> . The result should be Column=null
- hit Done and then do a refresh
If this solved yout problem then please mark it as the solution so others can see it.
Best,
Greg_Deckler
2 years agoCommunity Champion
Quenril Perhaps there is something in your Transform file function that is selecting columns perhaps?