web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Entity store in D365 F&O

(0) ShareShare
ReportReport
Posted on by 8

Hi All ,

D365 F&O has Entity store functionality in System administration . Example : Purchase , Sales , Inventory and production entity stores are available.

Could any one guide me how to view these entity data when users login to D365 as default screen ? Thanks !!

I have the same question (0)
  • Martin Dráb Profile Picture
    237,882 Most Valuable Professional on at

    Can you please explain your requirement? If you want to see data in F&O, why do you need Entity store? You can simply use a form, can't you?

    Also, it's not clear what you mean by "default screen".

    And no, there aren't separate entity stores for Purchase, Sales etc. Data from all modules are in a single entity store.

  • Anup Shah MSFT Profile Picture
    on at

    To add to above, the entity store in Dynamics 365 Finance and Operations (Finance and SCM), is mainly used for analytical reporting, and can be integrated with PowerBI. But it's just one entity store as already mentioned.

    Doc links:

    docs.microsoft.com/.../author-distribute-power-bi-reports

  • Verified answer
    Crispin John Augustine Profile Picture
    37,081 on at

    In D365FO UI, you can see those cubes' data in the following places: (if PowerBI Embedded is enabled, and you have refreshed those data in Entity store)

    Procurement and sourcing > Inquiries and reports > Purchase performance analysis > Purchase and spend analysis,

    Sales and marketing > Inquiries and reports > Sales performance analysis > Sales and profitability performance,

    Warehouse management > Inquiries and reports > Warehouse performance analysis > Warehouse performance,

    Production control > Inquiries and reports > Production performance analysis > Production performance

  • Verified answer
    Rahul Mohta Profile Picture
    21,032 on at

    +1 Crispin

    One cannot directly view data within entity store

    need to use PowerBI embedded to expose that information and they are availlable in modules as suggested as well as in analytical workspaces

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans