Forum Discussion

Quenril's avatar
Quenril
Resolver I
2 years ago
Solved

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: ...
Need Help
  • MNedix's avatar
    MNedix
    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,

     

MNedix's avatar
MNedix
Solution Sage
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,

 

Quenril's avatar
Quenril
Resolver I
2 years ago

Hi MNedix,

 

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

 

Quenril