Tuesday, December 19, 2017

Power BI / Excel: OData feed Dataformat error "The given URL neither points to an OData service or a feed"

Leave a Comment
Scenario:
While updating some of columns in Power BI / Excel I started facing following error:

DataFormat.Error: OData: The given URL neither points to an OData service or a feed:"http://SomeEPMServer/pwa/_api/Projectdata/Projects". Although if you tried same rest api/odata feed in browser it fetch related project feed.

Causes:
 Somehow my credentials for data source which I set to used as current user credentials has not been working.

Solution:
Delete current set up credentials from Datasource settings-> Edit permission and update it to be used as current windows account at organizational level.
If You Enjoyed This, Take 5 Seconds To Share It

0 comments: