Getting data from Dynamics 365

[Birdjo]

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.

[vanessafvg]

@Birdjo

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

[Birdjo]

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]

@Birdjo  there isn't just crm there

Content packs available for download.

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.

• Download the Microsoft Dynamics CRM Online Sales Manager .PBIX

• Download the Microsoft Dynamics 365 (online) Service Manager .PBIX

[Birdjo]

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

[Birdjo]

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.