Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Helper IV
9 years ago
Solved

Error trying to get data from Microsoft Dynamics CRM

Hi! I have exported a XML file from microsoft CRM with a simple list of data I want to connect to PowerBI. However it wont let me see the data in columns. I have tried to things:   1. Connect...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Kristofferaabo,

    You can discover the URL of your organization following the instructions in this blog . After you get the "Organization Service" URL, for example, https://XXXX.api.crm8.dynamics.com/XRMServices/2011/Organization.svc. Just simply add "Data" word to "Organization", so the URL will be https://XXXX.api.crm8.dynamics.com/XRMServices/2011/OrganizationData.svc, enter this URL in Power BI Desktop.

    For your second question, could you please describe more details? In Power BI Desktop, you can use organizational account to connect to Microsoft Dynamics CRM, you can check this similar blog to get more details. Dynamics CRM Online entry displayed in this blog has been changed to Dynamics 365 in the new release of Power BI Desktop.

    Thanks,
    Lydia Zhang

  • Kristofferaabo's avatar
    Kristofferaabo
    9 years ago

    Hi again!

     

    thanks for this link, I found my organization service link. But I think I still need authorization,. I have made a ticket with IT regarding this.


    Best regards

    Kristoffer

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Kristofferaabo,

You don't need to export XML file from CRM and connect to XML in Power BI Desktop.

Do you connect to Microsoft Dynamics CRM online or on-premises Dynamics CRM from Power BI Desktop? 

If you connect to Dynamics CRM online, please use “Get Data->Dynamics 365” option in Power BI Desktop as shown in the following screenshot. You would need to enter the OrganizationData.svc URL and use oAuth2 authentication method to connect to the data source.


However, if you connect to on-premises Dynamics CRM, please use “Get Data->OData feed” option in Power BI Desktop as follows.


For more details about connecting to Dynamics CRM, please check the following articles.

{In Depth} Power BI and Dynamics CRM on-premise–When and how it works?
Use Power BI with Microsoft Dynamics 365

Thanks,
Lydia Zhang

Kristofferaabo's avatar
Kristofferaabo
Helper IV
9 years ago

HI Lydia! Thanks for your reponse sounds quite straight forward but I'm not sure I have the rigtht authrozation for this, or perhaps the right versions avavilable.

 

Currently I'm only a read-only uder of our CRM system, I have made some simple lists (employee workload) which I want to link to powerbi and embed in sharepoint, or stand alone reports.

 

How do I get the OrganizationData.svc?

 

Secondly how can I connect CRM to microsoft 365 (which i can login to)

 

Does this makes sense?

Kristoffer

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Kristofferaabo,

    You can discover the URL of your organization following the instructions in this blog . After you get the "Organization Service" URL, for example, https://XXXX.api.crm8.dynamics.com/XRMServices/2011/Organization.svc. Just simply add "Data" word to "Organization", so the URL will be https://XXXX.api.crm8.dynamics.com/XRMServices/2011/OrganizationData.svc, enter this URL in Power BI Desktop.

    For your second question, could you please describe more details? In Power BI Desktop, you can use organizational account to connect to Microsoft Dynamics CRM, you can check this similar blog to get more details. Dynamics CRM Online entry displayed in this blog has been changed to Dynamics 365 in the new release of Power BI Desktop.

    Thanks,
    Lydia Zhang

    • Kristofferaabo's avatar
      Kristofferaabo
      Helper IV
      9 years ago

      Hi again!

       

      thanks for this link, I found my organization service link. But I think I still need authorization,. I have made a ticket with IT regarding this.


      Best regards

      Kristoffer