Microsoft Dynamics 365 | Integration, Dataverse...

Table Export is available, Entities are not visible

(0) Share

Report

Posted on by AU-27040850-0

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)

Sort by

Suggested answer

Martin Dráb 240,175 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
AU-27040850-0 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 240,175 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