News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Can customers directly...

Finance | Project Operations, Human Resources, ...

Suggested answer

Can customers directly access the AxDW (Entity Store) database in D365 F&O?

(1) Share

Report

Report

Posted on by SR-13050944-0

4

We are a customer using Dynamics 365 Finance & Operations via a vendor-developed environment. I would like to confirm whether customers are allowed to connect directly to the AxDW (Entity Store) database — for example, via Power BI Desktop using Azure SQL connection.

Has anyone here (customer-side) successfully gained access to AxDW directly? Or does it strictly depend on the vendor / system admin granting permissions in Azure SQL?

Any experience or confirmation from Microsoft engineers or MVPs would be appreciated.

Categories:

Dynamics 365 Finance

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Jonas "Jones" Melgaard 4,159 Super User 2025 Season 1 on at

Like (0)

Report

Can customers directly access the AxDW (Entity Store) database in D365 F&O?

Granted that I'm MVP as in Minimum Viable Product on the best of days, I work a bit with analytics at us (customer) and have some experience.

No, it's not possible and never will.

D365 FinOps (Cloud) is a fully SASS solution, and you will never be able to access the backing databases.

If you want to do reporting against the AxDW, you need to implement your reports as Embedded BI reports:

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/power-bi-integration-entity-store?context=%2Fdynamics365%2Fcontext%2Fcommerce

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/analytics?context=%2Fdynamics365%2Fcontext%2Fcommerce

Some articles mention that you can trickle feed the entity store to a data warehouse, but that stuff is deprecated. Microsoft is investing heavily in Fabric at the moment, so that's the way the product is moving.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

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

#1

Martin Dráb 601 Most Valuable Professional

#2

Abhilash Warrier 416

#3

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans