Power BI Community API - integration

[vojtechsima]

Hello, guys,
I am wondering, I want to create a report that takes data from profiles of my colleagues here in Power BI Community and I want to create a simple report that would showcase how many kudoes they got, accepted solutions etc.

Is there a way how to integrate Power BI Community data to Power BI Desktop?

Thank you

[v-yiruan-msft]

Hi @vojtechsima ,

I created a sample pbix file(see the attachment), please check whether that is what you want.

Best Regards

[vojtechsima · Accepted solution]

Hi, @v-yiruan-msft 
I finally figured it out, I used your core solution and added dynamic page recognition and put it all together and it works.

Sending sample here.

[v-yiruan-msft]

Hi @vojtechsima ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here, it will help the members with the same needs as you. Thank you for your contribution and time.

Best Regards

[vojtechsima]

Hi, @v-yiruan-msft 
This is a great start, thank you.
But, I might need a little bit more specific result, I'd like to have a timestamp of when did they score the points.
I think a workaround is to each day get the "Last Day (24 Hours)" leaderboard and store it somewhere at my endpoint and then each day add a timestamp.
Do you think it would be possible to load all pages from the Kudos and Solution Leaderboard, please?