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
Datatouille - I fixed the issue with the error. However the date/time type was an issue, is there a way to do date time?
GilesWalker,
You can convert the date columns from Date/Time type to Date type, then apply the M code that Excelside provides.
Regards,
Lydia