Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingApplied 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting