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

(0) Share

Report

Posted on by Hamada Ibrahim

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

This PowerBI fields for same entity

All responses (7)

Answers (0)

Nya 29,056 on at

Like (1)

Report

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 15 on at

Like (0)

Report

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 29,056 on at

Like (0)

Report

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 15 on at

Like (0)

Report

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 29,056 on at

Like (0)

Report

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 15 on at

Like (0)

Report

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 29,056 on at

Like (0)

Report

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?