cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Birdjo Member
Member

Getting data from Dynamics 365

Hello. Is here anybody who extracts data from Dynamics 365 for Operations. We implemented it recently in our organization and I am wondering how to extract data from the production environment. Would you like to share how you do it? Thank's in advance.

5 REPLIES 5
vanessafvg Super Contributor
Super Contributor

Re: Getting data from Dynamics 365

@Birdjo

 

https://technet.microsoft.com/en-us/library/dn708055.aspx


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Birdjo Member
Member

Re: Getting data from Dynamics 365

I have tried with this:


https://OrganizationName.api.crm.dynamics.com/api/data/v8.1

 

But it didn't work. And we're using Dynamics 365 for Operations, not CRM.

 

I would like to be able to read and extract from all the tables and entities in the database.

 

vanessafvg Super Contributor
Super Contributor

Re: Getting data from Dynamics 365

@Birdjo  there isn't just crm there

 

The Microsoft Dynamics 365 content packs support the default out-of-box entities. However, you can customize the following content packs by downloading the .PBIX file and then using Power BI Desktop to customize the content pack before uploading it to the Power BI service.


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Birdjo Member
Member

Re: Getting data from Dynamics 365

I don't need content packs. I want to develop my own report.

 

Birdjo Member
Member

Re: Getting data from Dynamics 365

So far I managed to access the entity store

Here's the M Code for that:

let
    Source = OData.Feed("https://CompanyName.operations.dynamics.com/data")
in
    Source

But I am still not sattisfied because I can't find an entity for the production jobs data.
Maybe I will have to build entities which is OK, but currently I don't know how.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,334 guests
Please welcome our newest community members: