Forum Discussion
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:
I have also updated to the correct number of columns in my sample file (33) and my sample file shows the missing columns, however when I load this the column does not pull through into my data table and there are only 32 columns....
Any ideas please?
Thank you
Quenril
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,
3 Replies
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,
Hi MNedix,
Thank you so much, that's done it! Star!
Quenril
Quenril Perhaps there is something in your Transform file function that is selecting columns perhaps?
