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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Columns are missing wh...
Finance | Project Operations, Human Resources, ...
Answered

Columns are missing when connecting to D365 FO with ADF

(0) ShareShare
ReportReport
Posted on by Andrejs Gordijenko 10

Hello experts,

I am new here, please look at the question and guide me to the respective community if the question is not relevant here. Thank you in advance!

The issue is, that while connecting from Azure ADF using Dynamycs AX connector, we do not see all the columns of several entities.

4300.Untitled.png

For example, here the column DIMENSIONATTRIBUTETYPE is not available.

We are using service principal authentication.

We also have an organizational account, which, being used with PowerBI Odata connection, can see all the columns of this entity.

What else and where must be set in order to see all the columns via ADF?

Any help is much appreciated!

Andrejs

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: Columns are missing when connecting to D365 FO with ADF

    Do you mean Azure Data Factory by ADF?

    If you use service principal authentication, what roles does the user have that you linked to this app id in Azure Active Directory Applications form in D365FO?

  • Andrejs Gordijenko Profile Picture
    Andrejs Gordijenko 10 on at
    RE: Columns are missing when connecting to D365 FO with ADF

    That is correct, by ADF I mean Azure Data Factory.

    The app is registered with the same organization account we use in Power BI.

    I think this user is an admin - I need to recheck it.
    Update - thats correct, the user is a system admin.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,373 Super User 2025 Season 2 on at
    RE: Columns are missing when connecting to D365 FO with ADF

    Hi Andrejs,

    What exact data entity did you use? Is PRI_DIMENSIONATTRIBUTE a custom data entity? Can you check if the field is part of the data entity fields and not set as hidden?

  • Andrejs Gordijenko Profile Picture
    Andrejs Gordijenko 10 on at
    RE: Columns are missing when connecting to D365 FO with ADF

    Hi Andre,

    At my current location I do not have access to D365FO interface to tell if PRI_DIMENSIONATTRIBUTE is a custom entity. I will have that info on Monday.

    But this is what I see in Azure (on the left, result is the same for both Odata and AX connectors), and on the right the PowerBI connection using the same account the service principal is mapped to:

    1030.Untitled.png

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: Columns are missing when connecting to D365 FO with ADF

    What you are showing is a custom entity, we can determine it from the name, as well as the fact that you are seeing RecIds. The standard entities never expose RecIds since they are intended for the systems's internal use only.

    I would expect PowerBI Odata connection definetely show the same fields than ADF OData connection, since both are using the same connection (OData). If you read the OData endpoint directly in browser (yourD365URL/Data/[YourEntityPublicCollectionName]) I assume you see all the columns as well?

    The authentication method should not impact this, assuming the same user account and user role is used / set up for both.

    I'm not familiar with ADF. Perhaps there was some column list that you defined when connecting, and you excluded this one column?

  • Andrejs Gordijenko Profile Picture
    Andrejs Gordijenko 10 on at
    RE: Columns are missing when connecting to D365 FO with ADF

    Nikolaos, there is no field list defined from ADF side - its just the "preview data" from selected entity without any filtering except for number of rows to be shown.

    I also would expect for both Odata connections (both from ADF and PowerBI) to return the exact same result, but its not.

    Regarding access with URL - I see the empty screen, which makes me think the entity is accessible only with credentials, which I get no prompt for while trying from the browser.

  • nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: Columns are missing when connecting to D365 FO with ADF

    Yes, you need to be logged in or login in order to access the system. This applies also to all data entities. Perhaps try to login to D365FO first before trying to access the OData URL?

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: Columns are missing when connecting to D365 FO with ADF

    By the way, ADF documentation says that OData complex types are not supported. Perhaps OData Enum is not supported, either? The missing column is an Enum.

    docs.microsoft.com/.../connector-odata

  • Andrejs Gordijenko Profile Picture
    Andrejs Gordijenko 10 on at
    RE: Columns are missing when connecting to D365 FO with ADF

    I indeed was able to login into D365FO and could see the metadata from this entity. All fields are available. I could also see that it is indeed a Enum, which does not seem to be mapped into  some type in ADF. I will consult a person who did the export project for this entity. Thanks a lot in the meantime!

    Update: we have checked several entities, and indeed, none of the fields which are of type ENUM are visible in ADF. A big pity that is, but nothing we can do.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: Columns are missing when connecting to D365 FO with ADF

    A workaround is to create a virtual string (or int, if you wish) field in the entity and "translate" the enum value into that field during export.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 865 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 582 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans