Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.