Forum Discussion
OData Feed - Selected Fields Only
I am familiar with Power Query but the company I work for is migrating from Great Plains to Business Central.
I am trying to get familiar with using OData URLs from Business Central.
From image below, I am trying to pre filter a OData URL so that I can limit the dates and fields being brought into Power Query. (I am fully aware I could do these steps within Power Query but I am trying to determine if its faster pushing this query back to the source)
The OData URL seemingly works but filtering posting dates correctly and showing only posting dates as a field. However, why does the query pull in the fields I am not selecting? Any way to just bring in the fields I need?
OData URL Example
https://HIDDEN/G_LEntries?$select=Posting_Date & filter=(Posting_Date ge 2023-12-01T00:00:00.0Z and Posting_Date le 2025-04-30T00:00:00.0Z)
Results
5 Replies
Try specifying the ODATA version, and escape special characters.
Sorry, not sure what you mean. Upon further reading on the topic, if I want to connect Business Central to Excel maybe I should be looking into Power BI Dataflows. Setting up a Dataflow in Power BI and then Connecting Excel to the Dataflow.
The Power BI ODATA connector does not implement the full ODATA specification, and it behaves differently for ODATA3 and ODATA4.
