Access AXDW of on-cloud D365 FO prod database

[ScottWalter]

Hi power Bi community,

I want to access the axdw of on cloud D365 FO database. How do I access it for power bi reports?

If I create a SQL database in azure and connect it with FO, on refershing the entity store in on cloud D365 FO can I get a axdw in sql database?

Thank you

[JakobBecker]

Hi @ScottWalter, I believe by now you might have found a solution. However, for those still searching online, here's some guidance: The AxDW is populated from the Entity Store in Dynamics. You can access it via the Data Lake. For a more detailed guide, you can refer to this link: Make Entity store available as a Data Lake.