Synapse link/onelake link not showing all ProjTable fields

Helge Schroeder_Privat 31 Reputation points
2024-05-04T08:19:46.71+00:00

I am successfully exposing 102 F&O tables to Fabric using Synapse link with link to onelake.

I see however that for the Project table (ProjTable) some columns are missing.
These are the 3 "Project report sort fields". (sortingId, SORTINGID2_, SORTINGID3_).

Are the sortingId stored in an array in D365 F&O, and is that the reason they are not exposed to Dataverse/fabric? I need those sorting fields for reporting, so if there is a workaround (for example another table with the relationship between project and field) I would be happy.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,638 questions
{count} votes

Accepted answer
  1. VarunTha 4,430 Reputation points Microsoft Vendor
    2024-05-04T08:53:41.6633333+00:00

    Hi Helge Schroeder_Privat,

    This topic is currently not supported in the Q&A forums.

    I recommend initiating a new discussion through the Microsoft Power Apps CommunityModerators are readily available there to assist you and provide guidance.

    Please don't forget to Accept helpful answer and close this thread.
    Thank you.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful