FITBIT - direct connection

[vrossouw]

Hi, any idea if it is possible to connect directly with your FITBIT charge 3 data through Power BI?

I can see there is a download data option, but I want to connect directly to the data?

Thanks

[ankeet1]

Not knowing exactly how you intend to use this data, here's a roundabout way to do so.

1. Use IFTTT to nightly export Fitbit data to Google Sheets

2. Use the connection to Google Sheets directly from Power BI to get the data.

Would that work? I see that your question is just about 5 years old! You have moved on and forgotten about it. But if you have not, let me know if you found a better solution! 🙂 

[jeffshieldsdev · Accepted solution]

Not possible OOTB, but Fitbit does have an API you can connect to: https://dev.fitbit.com/build/reference/web-api/

You have to create a new app and authroize it to get a Bearer token you can use in Power Query:

let
    URL = "https://api.fitbit.com/1/user/-/activities/date/2018-12-31.json", 
    Options = [
        Headers = [
            Authorization = "Bearer token"
        ]
    ],
    Source = Json.Document(Web.Contents(URL, Options))
in
    Source

[Anonymous]

Hello @jeffshieldsdev 

I'm trying to create a custom conector to fitbit right now and totally missing the boat on understanding, can you help me?

So, I want to create a custom connector, I go into the custom connector wizard and start from blank, it asks for a client key/secret so I go to the fitbit api site to register for access.  In their app registration system they ask you for a Callback URL, you need this in order to gain access to the key/secret.  However, my understanding is that this Callback URL is the same thing as a the "Redirect Url" provided in the OAuth2.0 wizard page of the custom connector creater, for powerapps to generate this URL is requires the key/secret.  This means that I will never be able to apply to gain access to the API because I don't have a Callback URL.

What am I missing here?

Cheers,

A Cold Canadian

[v-frfei-msft]

Hi @vrossouw,

Based on my test, it is not possible to meet your requirement currently. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Frank