Forum Discussion

Nourhan's avatar
Nourhan
New Member
8 years ago

Getting data from Dynamics 365 for operations

When i'm trying to get data from Dynamics 365 to power BI desktop i got this error while trying to connect :Details: "OData: The given URL neither points to an OData service or a feed: 'https://login...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Nourhan,

 

Based on error message, it seems like you have inputted the invalid api url, can you please share some detail contents? 

 

 

Sample url:

https://[instance_name].crm.dynamics.com/api/data/v8.0/

 

Referencel link:

Operations supported by Online Management API

Manage instances

 

Regards,

Xiaoxin Sheng

Nourhan's avatar
Nourhan
New Member
8 years ago

hi Anonymous,

thank you for replying my url is: https://bingo-devdevaos.sandbox.ax.dynamics.com 

when i added /api/data/v8.0 it gives me this error : Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)"

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Nourhan,

     

    You can enter to 'setting -> customization -> develop resource' to find out the api url, please use the match url to get data.

     

    Regards,

    Xiaoxin Sheng