Synapse link/onelake link not showing all ProjTable fields

Question

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.

Answer 1

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.