Forum Discussion

amaleranda's avatar
amaleranda
Post Patron
6 years ago
Solved

Get Data from WEB LIKE JSON string

Hi Gurus,   Did you happen to know what get data method should I use to get below image. I tried Get Data -> JSON but seems I do not get the drop down option open file as. Any help would be highly ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Is this a public API?  If so, you can provide it and the community can provide the needed M code.

     

    Does the Source step of your query look like this?  (check by clicking on Advanced Editor or viewing the Formula Bar in the query editor)

     

    let
    Source = Json.Document(Web.Contents("http://mywebapi"))
in
    Source

    Pasted this from here - https://www.edureka.co/community/26876/how-can-i-connect-my-web-api-with-power-bi-reports

     

    If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

If you are trying to connect to a Web API that gives a JSON response, use the Web connector instead.  It will recoginize the response as JSON and you navigate/extract your data from there.

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • amaleranda's avatar
    amaleranda
    Post Patron
    6 years ago

    mahoneypat  it did not give me that option.

    • mahoneypat's avatar
      mahoneypat
      Microsoft Employee
      6 years ago

      Is this a public API?  If so, you can provide it and the community can provide the needed M code.

       

      Does the Source step of your query look like this?  (check by clicking on Advanced Editor or viewing the Formula Bar in the query editor)

       

      let
    Source = Json.Document(Web.Contents("http://mywebapi"))
in
    Source

      Pasted this from here - https://www.edureka.co/community/26876/how-can-i-connect-my-web-api-with-power-bi-reports

       

      If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

      Regards,

      Pat