1 ACCEPTED SOLUTION
Applied steps do get applied. But be aware that the Refresh Preview and Refresh All steps in Power Query still often only give you a quick overview. So if you have 1,000,000 records, and add a record, there is a good chance in Power Query it will be tough to see that the steps applied to record 1,000,001. But when it loads to the model you'll see it there.
This is especially true if you are relying on the Column Distribution or Column Profile data. If that is the issue, look in the lower left corner if your screen, and you'll see something like this:
You can click on the "Column Profiling based on top 1000 rows" and change it to look at the full data set, be forwarned if you have tens of thousands or records it will get sluggish, and millions of records will cause you to wait 2-3 min between the application of new transformations.
Can you explain perhaps with images and a copy of your M code (from the Advanced Editor) why you think the new records are not being added.
Applied steps do get applied. But be aware that the Refresh Preview and Refresh All steps in Power Query still often only give you a quick overview. So if you have 1,000,000 records, and add a record, there is a good chance in Power Query it will be tough to see that the steps applied to record 1,000,001. But when it loads to the model you'll see it there.
This is especially true if you are relying on the Column Distribution or Column Profile data. If that is the issue, look in the lower left corner if your screen, and you'll see something like this:
You can click on the "Column Profiling based on top 1000 rows" and change it to look at the full data set, be forwarned if you have tens of thousands or records it will get sluggish, and millions of records will cause you to wait 2-3 min between the application of new transformations.
Can you explain perhaps with images and a copy of your M code (from the Advanced Editor) why you think the new records are not being added.
