Forum Discussion
IamTDR
Responsive Resident
Responsive ResidentOData 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 b...
lbendlin
Super User
Super UserTry specifying the ODATA version, and escape special characters.
IamTDRResponsive Resident
Responsive ResidentSorry, 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!