Getting data from Dynamics 365 for operations

[Nourhan]

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.microsoftonline.com/bingo.eg/wsfed?wa=wsignin1.0&wtrealm=spn:00000015-0000-0000-c000-0...'

[v-shex-msft]

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]

hi @v-shex-msft,

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)"

[v-shex-msft]

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