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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Super User
Super User

@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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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