Forum Discussion

speschka's avatar
speschka
Regular Visitor
9 years ago
Solved

Custom Data Connection Returns JSON But Desktop App Says OData Not Service or Feed

I've been working on a custom data connector for Power BI desktop that consumes data from a REST API we've built that is secured by Azure AD.  I thought I was finally through the hard part - getting ...
  • Anonymous's avatar
    Anonymous
    9 years ago

    HI speschka,

     

    If you want to use Odata feed connector, you should confirm the data source is odata type.
    For you scenario, I think you can try to use web.content with json connector.

     

    Sample:

    source=Json.Document(Web.Contents("https://www.foo.com/api/data/powerbisummarydata"))

     

    Reference link:

    M Query to use POST method on a Web API

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

HI speschka,

 

If you want to use Odata feed connector, you should confirm the data source is odata type.
For you scenario, I think you can try to use web.content with json connector.

 

Sample:

source=Json.Document(Web.Contents("https://www.foo.com/api/data/powerbisummarydata"))

 

Reference link:

M Query to use POST method on a Web API

 

Regards,

Xiaoxin Sheng