Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

D365 entity Fields don't appear in SSIS OData connection however it appears in PowerBI OData connection

Posted on by 15

Hi,

I'm working to extract D365 data from Azure server to our local DW server using MS SSIS via  connection, I notice that some fields don't appear in SSIS however when I use PowerBI to analysis data the fields are there,

can any one help me how to fix this issue as all of these fields are very important,

the fields those not appear are related to status of requests like PR and PO status based on its workflow.

this SSIS fields

SSIS-PR.JPG

This PowerBI fields for same entity

PowerBI-PR.JPG

  • Nya Profile Picture
    Nya 29,056 on at
    RE: D365 entity Fields don't appear in SSIS OData connection however it appears in PowerBI OData connection

    Hi,

    Since most of the users active in the general module are basically in the CRM field and are not familiar with F&O or SCM.

    You can try to post it to the forum of F&O.

    This is the forum where you are most likely to get the answers you want.

  • Hamada Ibrahim Profile Picture
    Hamada Ibrahim 15 on at
    RE: D365 entity Fields don't appear in SSIS OData connection however it appears in PowerBI OData connection

    Hi,

    but this issue is not related to certain module, it is common integration issue between D365 and MS SSIS

    BR

  • Suggested answer
    Nya Profile Picture
    Nya 29,056 on at
    RE: D365 entity Fields don't appear in SSIS OData connection however it appears in PowerBI OData connection

    Hi,

    Then it is recommended to post your issue to the specific forum for further help.

    Here are the links.

    (+) Dynamics 365 Finance - Forums, Blogs, Support 

    (+) Dynamics 365 Supply Chain Management - Forums, Blogs, Support

    (+) Dynamics 365 Human Resources - Forums, Blogs, Support

    There you can get more professional answers.

  • Hamada Ibrahim Profile Picture
    Hamada Ibrahim 15 on at
    RE: D365 entity Fields don't appear in SSIS OData connection however it appears in PowerBI OData connection

    Hi,

    Yes we use F&O, SCM, HR, Project and accounting, approx all modules

    BR,

  • Nya Profile Picture
    Nya 29,056 on at
    RE: D365 entity Fields don't appear in SSIS OData connection however it appears in PowerBI OData connection

    Hi,

    I mean that if you are using Finance and Operation in Dynamics?

  • Hamada Ibrahim Profile Picture
    Hamada Ibrahim 15 on at
    RE: D365 entity Fields don't appear in SSIS OData connection however it appears in PowerBI OData connection

    Hi, we are using data entity from D365 to extract data using MS SSIS and PowerBI

  • Nya Profile Picture
    Nya 29,056 on at
    RE: D365 entity Fields don't appear in SSIS OData connection however it appears in PowerBI OData connection

    Hi,

    Would you please specify which application you're using in Dynamics?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans