Does PBI allow me load 12 field and one month later load additional 3 more new field ?

[Paulyeo11]

Hi All

During Sept i load in all field from CSV file and only keep 12 field , on Oct i like to load additional 3 more field can ?

[amitchandak · Accepted solution]

@Paulyeo11 , You have to open a Data transform/edit query. Right click on the table, open advance editor, and modify the code there as per need.

Keep a backup of file.

[Anonymous · Accepted solution]

@Paulyeo11  Yes ofcourse  you can...The only thing to make sure  is not to change the source destination and refresh the .pbix desktop file you will be able to see the newly added rows.

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

[Anonymous · Accepted solution]

@Paulyeo11  Yes ofcourse  you can...The only thing to make sure  is not to change the source destination and refresh the .pbix desktop file you will be able to see the newly added rows.

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

[Paulyeo11]

Hi Hus,

Do you mean that i can not change the CSV file location , once i change the directory location from C:/Temp to C:/Test , it will not allow me to add more field name right ?

Paul Yeo

[Anonymous · Accepted solution]

@Paulyeo11 if you want to retain in the same location you can but in case if you change the location you will have to edit the data source setting in the .pbix else it will throw error "File not found"

Click on Home Tab-->Transform Data-->Data source settings-->follow the below screenshot

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

[amitchandak · Accepted solution]

@Paulyeo11 , You have to open a Data transform/edit query. Right click on the table, open advance editor, and modify the code there as per need.

Keep a backup of file.

[Paulyeo11]

Hi Amit 

Thank you very much.

I owe you too many beer.

Paul