OData Feed - Selected Fields Only

[IamTDR]

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

[lbendlin]

Try specifying the ODATA version, and escape special characters.

[IamTDR]

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.

[lbendlin]

The Power BI ODATA connector does not implement the full ODATA specification, and it behaves differently for ODATA3 and ODATA4.

[IamTDR]

I intend to use the Power BI Business Central connector. Doing research, it seems OData feed isn't best practice. 

[lbendlin]

Yeah, this article doesn't produce a warm and fuzzy feeling.

Enabling Power BI Integration With Business Central - Business Central | Microsoft Learn

Good luck!