impossible to fetch Odata on Dynamics365 saved query: The odata.context url is invalid

[fedebona]

I try to open an odata feed to a Dynamics365 saved query (something like https://<d365url>/api/data/v9.2/accounts?savedQuery=<guid>  ) and I get the following systematic error:

DataFormat.Error: The odata.context url 'https://<d365url>/api/data/v9.2/$metadata#accounts(<list of properties>)' is invalid

The context url is actually valid, and if I call that URL it works properly. Seems like the kind of context URL is not properly managed by PowerBI.

In odata.feed call I added the following set of options [Implementation="2.0", OmitValues=ODataOmitValues.Nulls, ODataVersion=4] with no luck

Did anyone face the same issue?

[Anonymous]

Hi @fedebona ,

Please make sure your URL is correct, and please try clear all Cache and User Permissions within the Power BI desktop datasource setting, then try type it when you connect Odata to see whether it work or not(please make sure the credential is correct).

By the way, you also could refer to How to connect an OData Feed to Microsoft Power BI for details.

Best Regards,
Community Support Team _ Caitlyn

[fedebona]

Hi @Anonymous ,

I  took the URL returned in odata.context and it works properly, returning the related metadata

I also cleared cache and checked credentials and they are correct. I'm sure because I'm fiddlering the network activity and the call to the saved query works and returns a valid odata response. The problem is that seems like the odata.context is not properly "digested" by PowerBI even if it is correct