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
jeffshieldsdev's avatar
jeffshieldsdev
Icon for Solution Sage rankSolution Sage
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