News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Expose F&O tables as D...

Finance | Project Operations, Human Resources, ...

Answered

Expose F&O tables as Dataverse Virtual tables (entities)

(1) Share

Report

Report

Posted on by LB developer

152

Hello everyone,

Does it support to expose F&O tables as virtual tables (entities) in Dataverse?

I knew it supported F&O public data entities, but not sure if there is any change we can make F&O tables available as well.

Thanks,

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

André Arnaud de Cal... 293,278 Super User 2025 Season 1 on at

Like (0)

Report

Expose F&O tables as Dataverse Virtual tables (entities)

Hi LB developer,

It is not possible to use F&O tables as virtual tables. Only the public data entities are supported. You use a workaround by using the Fabric or Synapse link where you can have table contents in a Data Lake. You can then use the SQL endpoint to create a new (read-only) virtual table in Dataverse.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2

Martin Dráb 231,998 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans