How can i analyze thingspeak data in Power BI

I would like to connect my thing speak channel to power bi and like to do predective analysis.

Answer 1

[Christopher Stapels]

Here is a demo showing how to read data from a REST call. Then you can use the Read data API call. I havent tried that demo myself though.

Here is an awesome video showing how to get jokes from chuck norris into power BI. Thank you for helping me find that video! ;)

Please use caution, some of the content from Chuck Norris might be offensive.

[Pamoda]

I tried to read Thingspeak channel using that method. But Power BI shows an error while reading the data. The method works for sites like Chuk norris joke. The problem is with ThingSpeak. This is the link I usesd "https://api.thingspeak.com/channels/2547190/feeds.json". Earlier it was a private channel then I made it public and droped apikey keyword as Power BI failed to retrive data. However, Power BI didn't work even after droping that. The link works well with my browser. Please help me to resolve the issue.

[Pamoda]

FInally I was able to figure it out. Power BI does not work if "https://" contains in the URL. We have to give the URL without that part to make Power BI working.

[Christopher Stapels]

Awesome, glad you got it working!