Forum Discussion
Power Query assistance
GilesWalker,
Based on my test, the error is due to the large amount in your table. If I filter the table to keep top 210000 rows, everything works well, if I filter the table to keep top 220000 rows, the error occurs. Consider to reduce the rows in your table.
Regards,
Lydia
GilesWalker,
I can't reproduce your issue. I would recommend you look into the "APPLIED STEPS" in Query Editor to check which step or which function causes the error.
And you can share the complete source data so that we can test it.
Regards,
Lydia
Anonymous here is a link to the file:
https://www.dropbox.com/s/6im3ezb6ivjqard/Test%20data.pbix?dl=0
Thank you for your help with this.
GilesWalker,
Based on my test, the error is due to the large amount in your table. If I filter the table to keep top 210000 rows, everything works well, if I filter the table to keep top 220000 rows, the error occurs. Consider to reduce the rows in your table.
Regards,
Lydia