Connect Power Bi to Chuck Norris API

[maxduff59]

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 connect to the API she do not face any difficulties whereas, personnally, I have an error which say that the connection is impossible.

[maxduff59]

I cannot access to the Advanced Editor screen because the error appears on the screen 

[Daryl-Lynch-Bzy · Accepted solution]

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.

[maxduff59]

It still do not work. Is it possible that it comes from the fact that I am using Power Bi on a Mac through Parallels Desktop ?

[Daryl-Lynch-Bzy]

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"