Forum Discussion

vrossouw's avatar
vrossouw
Icon for Helper III rankHelper III
7 years ago
Solved

FITBIT - direct connection

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
Need Help
  • jeffshieldsdev's avatar
    jeffshieldsdev
    7 years ago

    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
ankeet1's avatar
ankeet1
New Member
2 years ago

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! 🙂