Custom (filtered) webservices

(1) Share

Report

Posted on by Robin9700

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.).

Categories:

Dynamics 365 Business Central

All responses (1)

Answers (1)

Verified answer

YUN ZHU 76,221 Super User 2024 Season 2 on at

Like (0)

Report

Custom (filtered) webservices

Hi, if you add the ODada feed manually, you can try adding filters directly in Endpoint.

More details: https://yzhums.com/6117/#toc8

For example, https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox230/ODataV4/Company('My%20Company')/SalesOrders?$filter=Posting_Date ge 2023-04-02 and Posting_Date lt 2023-05-01

Hope this helps.

Thanks.

ZHU