Actualize source to see new columns in CSV file

[Anonymous]

Hi everyone,

I have some reports based on a dataset which have a csv file for source.

I recently added 10 columns to my source file and I'd liked to actualize my table in PBI to see those new columns but without losing all my mesures etc...

I successfully updated the data but I don't see the new columns in PBI desktop in my dataset...

Someone can help me?

Thank you in advance.

[AndrejZitnay]

Hello @Anonymous 

You need to click on Refresh after updating your data source.

[Anonymous]

Hi AndrejZitnay, 

thank you for your answer.

I did refresh after updating my datasource but I don't see any update in my PBI source...

I've added some columns to my csv file and I don't see those.

The file is at the same place as before.

I don't understand why I'm not able to update the structure of my file...

[AndrejZitnay]

Hello @Anonymous 

There are two options.

1st - can you change your file to .xlsf format.

Refresh will work fine and give you new columns

2nd - Here are few tips

https://community.powerbi.com/t5/Desktop/Add-an-extra-field-from-a-data-source/td-p/35681

https://community.powerbi.com/t5/Desktop/New-column-in-source-not-appearing-in-dataset/td-p/329649

https://community.powerbi.com/t5/Desktop/New-column-in-source-table-not-appearing-in-dataset-after/td-p/43884

Andrej

[Anonymous · Accepted solution]

Thank you @AndrejZitnay , I finally found my solution in one of the topic you provide me.

To see my new columns in my source, I modify a the value for "Columns" in the advanced editor :