Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

(1) 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
  • t4m7 Profile Picture
    t4m7 61 on at
    Missing SortId fields in ProjTable exported on Azure Synapse link
    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.
  • ShahzaibAhmed52 Profile Picture
    ShahzaibAhmed52 117 on at
    Missing SortId fields in ProjTable exported on Azure Synapse link
    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

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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans