Forum Discussion
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 connect to the API she do not face any difficulties whereas, personnally, I have an error which say that the connection is impossible.
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.
4 Replies
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"I cannot access to the Advanced Editor screen because the error appears on the screen
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.
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 ?
