Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Quenril
Resolver I
Resolver 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:

Applied steps source.jpg

 

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.... 

Correct.jpg

 

Any ideas please?

 

Thank you

Quenril

1 ACCEPTED SOLUTION
MNedix
Super User
Super User

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,

 



If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,

View solution in original post

3 REPLIES 3
MNedix
Super User
Super User

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,

 



If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,

Hi MNedix,

 

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

 

Quenril

Greg_Deckler
Community Champion
Community Champion

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors