Organisation Users FitBit Data access via Microsoft PowerBi

[Newbie_FitBI]

a newbie to FitBit, I am seeking advise on how I can achieve (if possible) for Microsoft PowerBI app to access my organisation FitBit users data. Once the users data is accessible, then use PowerBI app to present users FitBit data in meaningful dashboard.

From reading the FitBit Web API and I have setup the followings:

> Applications I registered via dev.FitBit site for PowerBI App (url)

> completed the OAuth 2.0 authorisation

Q: from the PowerBI app, I can not see how I can access these fitBit authorised data. Any advices on this would be very helpful and very much appreciated.

[Gordon-C]

Hi @Newbie_FitBI,

I've been searching around for a PowerBI example where someone has done this before, but I have not found anything.  Maybe someone in the community has something they would be willing to share. 

My initial thoughts are you would need to build out an application (maybe it's a Power BI integration layer) that the Fitbit users would authorize to share their Fitbit data with your Power BI solution.  Once you've received authorization, the integration layer would use the Web APIs to pull the data and display it in the Power BI application/dashboard.  This solution would be comparable to how users query Fitbit data using Excel (see this blog post).

Thanks!

Gordon