Microsoft Dynamics 365 | Integration, Dataverse...

Table Export is available, Entities are not visible

(0) Share

Report

Posted on by Community member

I am able to setup Synapselink and export the Dynamics 365 F&O tables to the data lake. I want to export the entities also along with tables, but it seems that only tables export is availabe in the power platfrom. I tried to look at the documentation

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/power-platform/enable-virtual-entities

I should be able to see following option in my environment

/Catalog

, but i am seeing following : , but i am seeing following

Any clues into what can be done.

All responses (3)

Answers (0)

Martin Dráb 232,866 Most Valuable Professional on at

Like (0)

Report

Table Export is available, Entities are not visible

You won't make it by yourself, but yes, the view will join all the necessary tables.

Your link is about exposing public F&O entities as virtual entities in Dataverse, which is a different thing than exporting F&O tables to Data lake.
Community member 4 on at

Like (0)

Report

Table Export is available, Entities are not visible

@Matin drab, when you say "re-create" entities baesd on tables, does that mean that i need to join "Ecoresproduct" and "Ecoresproductmaster" to get the same results that i used to get from the entity? Doesn't this link say we an export entities or is it explaining something else.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/power-platform/enable-virtual-entities
Suggested answer

Martin Dráb 232,866 Most Valuable Professional on at

Like (1)

Report

Table Export is available, Entities are not visible

The export to Data Lake supports tables only, but you can then create "re-create" entities there based on the tables. Check out Create F&O Data entities as View on Synapse SQL pool.