Power BI desktop gives error (415) Unsupported Media Type with only certain OData feeds from NAV

[burgesst]

Trying to connect Power BI Desktop to Microsoft Dynamics NAV 2016 via OData, both on premises.

Set up some OData feeds a few days ago, and those are still working. However, any new ones give the error "OData: Request failed: The remote server returned an error: (415) Unsupported Media Type. (Unsupported media type requested.)"

On one client, this can be fixed by replacing servername.domain.local with just servername in the Odata path, but on another it fails both ways.

You'd think it was a name resolution issue, but the exisiting Odata feeds to the same server address still work!

And ALL the Odata feeds work perfectly in Excel.  So why should only new ones be failing, and only failing in Power BI ?

Thanks

[JvdW · Accepted solution]

I've been struggling with this same issue for a few hours, and I think i've found the solution. Power BI caches data from OData feeds, meaning it will hold the data from the first time you consumed the OData feed. When you want to add data from a new NAV object and enter the URL using "Get Data" Power BI will return a error, because according to the cached data the newly added object doesn't exist. I've found 2 ways to solve this:

1. Lets say NAV gives you the following OData URL: http://localhost:7048/DynamicsNAV90/OData/Company(CRONUS)/Query. In Power BI Desktop: when pasting this link in the OData-feed using "Get Data" remove the last part of the URL (http://localhost:7048/DynamicsNAV90/OData/Company(CRONUS)/). This will open the query editor and shows you all the available objects in NAV(according to the currently cached data). Now go to "Start" in the ribbon and click "refresh preview". The OData feed should now be updated and the correct objects should be shown. From here you can select the object you want to use and load it in.

2. In Power BI Desktop: Go to "File"  and select "Options". Under "Data Load" you have the option to clear the cache. After doing this you can use "Get Data" and "OData-feed" as normal and the URL won't return the 415 error. 

Quite simple but it worked for me!

[priyankachauhan]

yes, the second method works . thank you

[AriaRen]

yes, the second method works perfectly~ thank you

[_jpujol_]

The second method works perfectly. Thank you very much!

[jrsantab1]

I used the second method (clearing the cache) and it worked perfectly.

[PavelV]

Thank you for exact recommendation!

[ptitta]

Same problem here. Someone have a solution. Some Odata works fine other no why?

Trying to understand the reason could help the solution

[GeertSchhneider]

I have exctly the same issue  (not working in powerBI - working fine in excel) - did you found a solution ?