API for Power BI Analytics

Hi there,

I’m trying to figure out a way to fetch data from Twitch in order for me to try and setup a Power BI analytics tool.

Can anyone help me out?

lists the endpoints available

Thanks. Problem is, it says I don’t have access to it. Do you know why that is?

Access to what?

Access to the data when entering the URL in Power BI

What URL?

This one: https://api.twitch.tv/helix/analytics/games

But it says I need a “OAuth token”, which I suppose is applied for here: https://dev.twitch.tv/console/apps/create

Once you’ve created an app in the developer console you can get an OAuth token by following the Auth Code flow https://dev.twitch.tv/docs/authentication/getting-tokens-oauth#oauth-authorization-code-flow

Keep in mind that to use the Get Game Analytics endpoint you need a token with the analytics:read:games scope, and it has to be granted to your app by a user account that’s a member of the organisation who have claimed that game on Twitch.

That is also assuming that Power Bi knows how to read that data.

I’d expect you would need to write an adapter to sit in the middle and shuttle data back and forth.

Since the analytics endpoints return links to CSV’s and then you have to go fetch the CSV

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.