Azure Synapse Link with F&O missing tables

Ameer Jaber 0 Reputation points
2024-03-19T08:57:53.9533333+00:00

Hello,

I'm facing this problem with synapse link, I did:

  • Connect F&O environment with power apps.
  • Established an incremental link with data lake.
  • I can see D365 Finance and Operation in the list of tables in manage tables of the link.

My problem is i can't find all the F&O tables in the list, i did follow Microsoft guide where i should go to (power apps --> advanced settings --> advanced search --> select available finance and operation tables --> search for the entity and set its visible to true) but i can't even find the table in the advanced search and the table isn't a custom table.

Please keep in mind:

  • It's a table and not an entity.
  • It's not a custom table.

Can someone help please, thanks in advance.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,330 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,320 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Smaran Thoomu 8,885 Reputation points Microsoft Vendor
    2024-03-20T07:40:28.48+00:00

    Hi @Ameer Jaber

    Thank you for reaching out to the community forum with your query.

    As I understand that you are unable to find all the F&O tables in the list while establishing an incremental link with data lake. To resolve this issue, you can try the following steps:

    • Check if the table is available in the data lake. If it is not available, you need to synchronize the table with the data lake.
    • Ensure that you have the necessary permissions to access the table in the F&O environment and the data lake.
    • Check if the table is available in the Synapse workspace. If it is not available, you need to create a linked service for the data lake in the Synapse workspace and then create a dataset for the table.

    I hope this helps. Let me know if you have any further questions.

    0 comments No comments