I'm trying to build some dashboards for a customer who is using Business Central Premium and one of the reports I have is to show capacity vs load of work centres.
I'm looking to use the "Work Centre Load" page which I've set up as a web service and can open in Power BI. The main issue that I'm having is that the initial dates for period start go back to year 0001 and when I try to reduce the rows or filter on dates after this year it errors or will only remove the first 5000 or 20000 rows in Power Query. Due to the number of rows being brought in for each work centre, I'm unable to filter this query or even bring it in to Power BI from Power Query.
Does anyone know of the best way to bring a table in like this and filter out non-relevant days?
To confirm, I've calculated work centre calendars for 2022 and 2023 and nothing before.
