Forum Discussion

Kristofferaabo's avatar
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