web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Missing Dynamics 365 F&O tables when creating a Link to Microsoft Fabric

(0) ShareShare
ReportReport
Posted on by 14

Hi Community,

 

We are creating a Link to Microsoft Fabric from our Dataverse environment.

While selecting tables for the link, we can see all the required tables under the Dataverse section. However, under the Dynamics 365 Finance and Operations (F&O) section, I see lot of tables, but required F&O tables are not available for selection when i search for it. I got the list of tables from semantic models which are currently being used.

Could you please clarify the following?

  1. Are there any features, configurations, or prerequisites that must be enabled for an F&O table to appear when creating a Link to Microsoft Fabric?
  2. Do the underlying F&O tables need to have specific properties enabled, such as change tracking or any other data-sharing configuration?
  3. Are there any restrictions on which standard or custom F&O tables are supported?
  4. Is there a recommended way to verify why a specific F&O table is unavailable?

The required tables exist in the F&O environment, but they are not listed in the F&O table-selection section while configuring the Fabric link.

Any guidance on the required configuration or troubleshooting steps would be appreciated.

Thanks.

Categories:
I have the same question (0)
  • Suggested answer
    Assisted by AI
    CU-1234529-002 Profile Picture
    133 on at

    Hi,

    Here's a quick rundown:

    1. Prerequisites: Make sure the base Dataverse-to-Fabric link is fully created and healthy first F&O tables won't show up if that base link isn't working. Also confirm your Dataverse environment is actually linked to your F&O environment (check in Power Platform admin center).

    2. Special properties needed: F&O tables need to be exposed as data entities in F&O (not just raw tables) to be eligible for the Fabric link. If a table only exists as a raw table with no corresponding data entity, it won't appear in the picker.

    3. Restrictions: Yes, only tables exposed as data entities are supported, similar to BYOD/entity export. Not every raw F&O table qualifies.

    4. How to check a specific table: Go to F&O → Data management → Entities, and search for that table/entity name. If it's not listed there as a data entity, that's likely why it's missing from the Fabric table picker too.

    Quick fix to try: Check if your missing tables have data entities built for them. If not, you may need to create/expose a data entity for that table before it can be linked.

    If all that checks out and it's still missing, it may need a Microsoft Support ticket.

  • CU12020826-0 Profile Picture
    14 on at

    Hi @CU-1234529-002 ,

    Thanks for the details. Do you have any Microsoft documentation, blog posts, or official references that outline the steps for validating these prerequisites:

    • Verifying the Dataverse-to-Fabric link health and configuration
    • Confirming the Dataverse and F&O environment linkage
    • Checking whether an F&O table is exposed as a data entity
    • Understanding the supported F&O entity requirements and limitations for Fabric Link

    Any official documentation or guidance would be very helpful for troubleshooting the missing tables.

    Thanks in advance.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    306,719 Super User 2026 Season 2 on at

    Hi,

    Thanks for your question. Note that the AI assisted reply above is not useful as it has a lot of incorrect details. Unfortunately the person who posted it, did not verify the AI generated content before pasting it here.


    To answer your questions:

    1+2+3: A table's property AllowRowVersionChangeTracking should be set to Yes. They also need to have a natural key. There is no requirement to have them created as data entities. Data entities with more than one data source aren't supported. With the Synapse link and Fabric link, the main focus from Microsoft is using tables. In case you need to have a data entity, it is recommended to recreate them as view in Fabric using the tables configured for syncing.

    4: You can check the table property in Visual Studio. You can activate standard and ISV tables by extending the table and change the value of the property mentioned above. For your own customizations, you can enable the property without a table extension. Note that the table still should have a natural key.

  • Subra Profile Picture
    1,958 Super User 2026 Season 2 on at

    Please move this question into forum Microsoft Dynamics 365 | Integration, Dataverse, and general topics.

  • André Arnaud de Calavon Profile Picture
    306,719 Super User 2026 Season 2 on at

    @Subra , in my opinion, the question fits in this F&O group on the forum. Table prerequisites is more F&O specific than the Fabric link, part of Dataverse. I don't see a reason to move the question. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291 Super User 2026 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 258 Most Valuable Professional

#3
Anton Venter Profile Picture

Anton Venter 221 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans