Applied steps and refresh data

[antalgu]

The problem I'm having is quite simple, I have an acces table with data in a certain path of the computer, and I have some applied steps that I used to work with that data. When I add data to the table and press "Refresh Preview" or "Refresh All" all data gets refreshed, but the applied steps don't apply to the new data. Am I missing any option? Do I have it manually? If it's manual isn't there any way to make it automatic?

[edhans · 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.