cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

Building custom OData feed for consumption in Power BI

I have a product that exposes an OData feed but requires authentication. That feed can be consumed in Power BI with no problems. 

 

I constructed an ASP.NET MVC Web API application to act as a wrapper around that existing feed, managing the authentication in the user's behalf. The results from the wrapper look almost identical to the results from the feed itself, except for some whitespace differences in the response body that result in a different content length. However, Power BI complains when I try to target the wrapper as an OData Feed. I'm getting the following error.

 

Error.png

 

The content type is specified in the MVC wrapper as application/json and the content of the response itself actually is JSON. I know Power BI supports that MIME type because the original feed returns the same content and it is consumed just fine.

 

Any ideas on where to look?

0 REPLIES 0

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.