Integração do Discourse Data Explorer com Power BI

Hi! Newish to Power BI, and very new to the Discourse Data Explorer, so bear with me.

I’m trying to connect, I’ve put in my forum URL, my username, and my password into the script at the top. I’ve run the test badges script in Data Explorer. However, when I try to connect on Power BI
I get this error:

I connect anonymously because if I try any of the other permissions in PowerBI it says the data must be collected anonymously.

Any tips?

I’m eventually trying to connect a whole bunch of our forums (several hundred) to PowerBI so we can have the analytics. If there’s an easier way to do that then manually like this I’d also be happy to hear it!

EDIT: I’m also a bit confused with the updated query for pulling all the data. Do I have to export as a CSV first? This isn’t a live link?

1 curtida