Forum Discussion
Power BI Power Query edits not being applied
The sorting and the pointer math are likely what's killing it.
I have recently seen a clever approach - after sorting, make a copy of the table containing only the entered date, then add a zero based index to one table and a one based index to the other. When you merge the tables back together you get the pointer math for free. Might want to try that.
I've confirmed it is at the very least not the sorting, as if I load the step before the pointer math, it load fairly quickly. I will see what I can do about trying out the method you gave me with the math and see if that helps. However, I don't believe this will fix the main issue. Currently, when I try to apply the changes, Power BI will not finish loading the database, and will eventually get stuck here:
Except it will be around the 300,000 mark.
Edit, it looks like that was wrong, as when I tried deleting the section that does the pointer math, it successfully applied the changes.