Microsoft Dynamics 365 | Integration, Dataverse...

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

I have the same question (0)

All responses (7)

Answers (0)

Nya 29,064 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Was this reply helpful? Yes No
Hamada Ibrahim 15 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nya 29,064 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Was this reply helpful? Yes No
Hamada Ibrahim 15 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

BR,

Was this reply helpful? Yes No
Suggested answer

Nya 29,064 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Hamada Ibrahim 15 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

BR

Was this reply helpful? Yes No
Nya 29,064 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No