topic Re: Power BI Community API - integration in Developer

Power BI Community API - integration

vojtechsima — Tue, 31 May 2022 10:51:18 GMT

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

Re: Power BI Community API - integration

Anonymous — Fri, 03 Jun 2022 02:43:23 GMT

Hi @vojtechsima ,

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

Best Regards

Re: Power BI Community API - integration

vojtechsima — Fri, 03 Jun 2022 08:06:01 GMT

Hi, @Anonymous
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?

Re: Power BI Community API - integration

vojtechsima — Mon, 06 Jun 2022 14:11:02 GMT

Hi, @Anonymous
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.

Re: Power BI Community API - integration

Anonymous — Tue, 07 Jun 2022 01:35:06 GMT

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