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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Missing Dynamics 365 F...
Finance | Project Operations, Human Resources, ...
Answered

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

(1) ShareShare
ReportReport
Posted on by CU12020826-0 18

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:
Dynamics 365 Finance
  • Suggested answer
    Assisted by AI
    CU-1234529-002 Profile Picture
    CU-1234529-002 385 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
    CU12020826-0 18 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.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,261 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
    Subra 2,331 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
    André Arnaud de Cal... 307,261 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. 

  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 2,699 Super User 2026 Season 2 on at

    Hi @CU12020826-0,

    To answer the four questions:
    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?

    A] Pre-requisites for Synapse link for Fabric setup in D365 FO include:
         - FO environment cloud hosted link to Power Platform (Dataverse) 
            environment.
         - Power Platform admin role and D365 System admin role (preferably 
           during configuration).
         - Allow Row version change tracking (DB Sync post enablement). 
    .    - Fabric workspace with proper capacity and storage account in Azure to 
            host the tables.

    2. Do the underlying F&O tables need to have specific properties enabled, such as change tracking or any other data-sharing configuration?
    A]Link to Fabric relies on row version change tracking enabled for Synapse link for Fabric.

    3. Are there any restrictions on which standard or custom F&O tables are supported?
    A] For standard tables if row based change tracking is enabled then the custom tables work. Tables like DataArea, UserInfo, SecurityRoles are included automatically and will be updated every day. Unsupported tables include staging tables/temporary tables, custom tables without rowversion, deprecated tables with DEL_ prefix. 

    4. Is there a recommended way to verify why a specific F&O table is unavailable?

    A] A F&O table not being available could be either because: 
        -  Allow row version change tracking is not being enabled.
        - Custom tables with no database synchronization or a model build is not 
           completed that leads to tables not being available or showing up on the 
           Dataverse side. 
    .    - Large tables like LedgerJournalTrans,CustTrans,VendTrans, InventTrans take some time to refresh between D365 and Synapse link for Fabric so refresh times could be different.

    References:
    https://learn.microsoft.com/dynamics365/fin-ops-core/dev-itpro/data-entities/rowversion-change-track
    https://learn.microsoft.com/power-apps/maker/data-platform/azure-synapse-link-select-fno-data

    Hope this helps. Happy to answer questions, if any.

     

     

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 August Top 10 Community Leaders

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 495 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
CU10121822-0 Profile Picture

CU10121822-0 366

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans