Hi all,
We use Power BI to create financial reports from Business Central through Webservices (OData). These reports tend to focus on the current and previous financial year.
As Power BI has recently been struggling with refreshing large tables from BC, we would like to limit the data that is imported from specific tables.
E.g. we use an OData-feed to load General Ledger Entries into our Power BI Dataflow, which contains data from 2018 and up. We only need data from 01-01-2022 and later to show up in Power BI.
Is there a way to create an OData-feed in Business Central for a filtered version of the Ledger Entries-table?
Bonus points if this can be a dynamic filter, so we don't have to repeat the process every 1 or 2 years (as in 2024, we will not need 2022-data anymore etc.).