New column in source table not appearing in dataset after refresh?

[cparker4486]

I found this post but it doesn't play out for me. http://community.powerbi.com/t5/Service/New-column-in-source-table-not-appearing-in-dataset-after/m-...

The only way I've been able to get new columns to appear is to change the Source line in the Advanced Editor. Specifically, I have to change the Columns value to reflect the current amount.

Source = Csv.Document(File.Contents("C:\source\file.csv"),[Delimiter=",", Columns=12, Encoding=1252, QuoteStyle=QuoteStyle.None]),

Is this the expected behavior or is it specific to CSV source type?

[v-qiuyu-msft · Accepted solution]

Hi @cparker4486,

I will report this issue internally, and keep you update once I get any feedback.

Best Regards,

Qiuyun Yu

[mr_101]

Hey,

Is this issue reslove as i am getting the same issue?

[rossgerber]

I'm having the same issue

[ankitpatira]

@cparker4486 it depends which refresh you're doing. if you go to query editor in power bi desktop and then do refresh then your metadata changes will come throuh. if doing refresh via power bi desktop home screeen then only data is refreshed.