New Column in source file not updating in powerbi

[gauravg3]

I added a new column in the source csv file (sharepoint), and when performed refresh data in power bi, alll data is getting updated except this new column.

Can someone pls guide what can be done to get the new column added as well.

Thanks

[Samarth_18]

Hi @gauravg3 ,

Have you removed any column in Power Query?

Thanks,

Samarth

[gauravg3]

Hi Samarth,

I haven't made any changes in power query. There is an existing custom column, which is there before adding the new column in source file.

Thanks

[Samarth_18]

@gauravg3 , If you refreshing on services then it will not work. Actually It will only fetch the data from previous source it will not add a new columns. For any metadata changes or structural changes, you have to refresh it in Power BI Desktop and then publish it.

[gauravg3]

I've tried refreshing in PowerBI desktop as well, still no luck.

[Samarth_18]

@gauravg3 , Hope we have already verified source path as well to check we are refreshing the correct file?

[gauravg3]

yes, I've verified the source file, and replicated this in a separate report as well and getting the same issue.

[Samarth_18 · Accepted solution]

Go to Advance editor, in the line "source = csv.document" you must be having one parameter for column for example column = <some value>, so could you please try to increase its number based on column numbers or try to set it as null. Hope it should fix your problem.

[Sk00]

Hi @Samarth_18 

Could you pls advise what do you mean by increase its number value based on column?

Thanks

[gauravg3]

yes changing the column value worked 🙂 many thanks