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...'
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
Regards,
Xiaoxin Sheng
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)"
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