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.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community member 4 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No