Forum Discussion
Solved
Power Query assistance
Hi everyone, I am trying to create a table in Power Query based off of another table in Power Query. The new table needs to have a row of data for every date that occurs between start and finish ...
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
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