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

Notifications

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 SortId fields ...
Finance | Project Operations, Human Resources, ...
Unanswered

Missing SortId fields in ProjTable exported on Azure Synapse link

(4) ShareShare
ReportReport
Posted on by Balasubramanian R 58
Hi,
 
On D365FO, does anyone face a situation on missing SortId fields on the ProjTable exported to Azure Synapse link? We have data in those fields that are required for reporting. Any help is appreciated.
 
Thanks,
B
I have the same question (0)
  • ShahzaibAhmed52 Profile Picture
    ShahzaibAhmed52 148 on at
    If Azure Synapse Link is configured to exclude certain fields, you may need to review the export schema to ensure the required field is mapped correctly. It's possible that customizations or filters were set up to limit fields for export, excluding those fields
  • t4m7 Profile Picture
    t4m7 61 on at
    Hi - I can also confirm that while i can see the 3 sortingid fields in the projtable in F&O, i do not see them in our OneLake. 
    I do think there is something odd about those fields.  
    1. If I look at projtable in the sysTableBrowser, all 3 have the same title "sortingid" even though the underlying field is sortingid_1
    2. Some time ago, we were unable to update those fields via the F&O connector...but we are able to update them using the Dataverse connector and virtual entity.
     
    I'm not a dev, so sometimes we have to do workarounds, so we are pulling that info via dataverse when we need it, but if you have a dev on your team, i suspect there is something funny about how those fields are defined in the first place...maybe they can check it out.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November 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... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans