Power BI not recognising additional column in csv source data

[Quenril]

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

[MNedix · Accepted solution]

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,

[Quenril]

Hi MNedix,

Thank you so much, that's done it! Star!

Quenril

[Greg_Deckler]

@Quenril Perhaps there is something in your Transform file function that is selecting columns perhaps?