Forum Discussion

maxduff59's avatar
maxduff59
Helper II
3 years ago
Solved

Connect Power Bi to Chuck Norris API

Hello everybody, I am trying to follow a Youtube Video which describe how to get data from the Chuck Norris API (link: https://www.youtube.com/watch?v=FuGZoRkRmyI). However, when she is trying to ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Could you try the script below to see it works?

    Then try from scratch using the following URL:

    https://api.chucknorris.io/jokes/random

    If either of these work, you might have network or firewall issue.  I would try testing in another application like Postman or VS Code to confirm that it is not a Power BI issue.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi maxduff59 - could you please share the code from the Advanced Editor screen?  Does it look like this?

let
    Source = Json.Document(Web.Contents("https://api.chucknorris.io/jokes/random")),
    #"Converted to Table" = Table.FromRecords({Source}),
    #"Expanded categories" = Table.ExpandListColumn(#"Converted to Table", "categories")
in
    #"Expanded categories"