Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hi @cparker4486,
I will report this issue internally, and keep you update once I get any feedback.
Best Regards,
Qiuyun Yu
I spoke with Microsoft Support and have a fix.
PBI Desktop doesn't recognize the new column for March that was added:
When you open the advanced editor, you will see that the original number of columns is defined:
Remove the definition of the number of columns:
When you click "Done" and return to the query editor the new column appears:
Hey,
Is this issue reslove as i am getting the same issue?
I'm having the same issue
@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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |