Announcements
No record found.
Hi,We're using Power BI to report on data from our Dynamics 365 for Finance and Ops instance. I've built a function in Power Query to convert the JSON reponse from the oData end point for a given entity to a table. Now I'm trying to figure out a way to list all the available entities.Is there a way to obtain a list of all the available data entities via the API?Thanks!
Hi AUaero,
You can find them in the D365FO data management workspace but for what reason do you need a list of all available entities?
I assume that you won't need all of them, do you?
Best regards,
Ludwig
To get a list of all OData entities from Dynamics 365 F&O use URL as : [Your organization's root URL]/data/
example: mycomany.sandbox.operations.dynamics.com/data
look at MS docs link docs.microsoft.com/.../odata for other features in D365FO.
If you go to Organization admininstration > Setup > Office integration > Excel workbook designer, you will get a list of all public entities with the functional name and the public name. The entity list from the Data Management workspace is only showing the entities which can be used with data management and might have some differences with the public entity list.
You can get it using code as well. For example by using metadata API . In below links see Martin's verified answer. You can use GetDataEntityViewNames method from API to get list of all data entities .
community.dynamics.com/.../enumerate-label-prefix-for-label-search-functionality
There are a couple of Data Management entities in F&O, which you can use to build a pbix.
Alternatively, there are Excel entity and field lists in the technical reference documents;
mbs.microsoft.com/.../axtechrefrep
Finally, in addition to the entities that you're likely connecting to, there's also a Datamart behind F&O that contains a host of pre-built cubes and measures and drives a lot of the in-built reporting. You'll need a VM set up to access this though.
You can review here - ajit-newdynamicsax.blogspot.com/.../how-to-list-down-data-entities-with.html
Hi, May I know whats the purpose of getting all the Data entity list. As suggested by Vinit, you can see all public data entity using Odata, try this link, docs.microsoft.com/.../odata
Please check all the replies and mark the answers as verified if those answers your question.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 658
André Arnaud de Cal... 468 Super User 2026 Season 1
Syed Haris Shah 333 Super User 2026 Season 1
