Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
2 years ago
Solved

get data from Strava website

I need to import last week's leader board from Strava into Power BI, below is the url which gives me the correct data ( i hided senstive part in the url), however when I connect Power BI using this w...
Need Help
  • Jeanxyz's avatar
    Jeanxyz
    2 years ago

    I know it sounds crazy, but the url get changed in advanced view as well. A colleague finally figured it out for me, here are the steps: 

    1. go to strava site, select the table, open developer console to see the script being used to generate the table

    2. copy the script to powershell and remove the unnessary lines, 

    3. go to Power BI, choose web connector - input

    ****

    source =

    Json.Document(Web.Contents("https://www.strava.com/xxxx/1117610/leaderboard?week_offset=1%22", [Headers=[#"x-requested-with"="XMLHttpRequest", Accept="text/javascript, application/javascript, application/ecmascript, application/x-ecmascript"]]))

    ****

PhilipTreacy's avatar
PhilipTreacy
Super User
2 years ago

Hi Jeanxyz 

 

Why do you say it's removing the ?week_offset=1 part or the URL?  It shouldn't.  Where are you seeing this happen?

 

If you create a Web query and enter the URL, then click on Advanced, you shoudl see the URL that will be used in the Preview area

 

 

and when it's connecting you should see the full URL displayed like so

 

 

Regards

 

Phil

 

Jeanxyz's avatar
Jeanxyz
Power Participant
2 years ago

I know it sounds crazy, but the url get changed in advanced view as well. A colleague finally figured it out for me, here are the steps: 

1. go to strava site, select the table, open developer console to see the script being used to generate the table

2. copy the script to powershell and remove the unnessary lines, 

3. go to Power BI, choose web connector - input

****

source =

Json.Document(Web.Contents("https://www.strava.com/xxxx/1117610/leaderboard?week_offset=1%22", [Headers=[#"x-requested-with"="XMLHttpRequest", Accept="text/javascript, application/javascript, application/ecmascript, application/x-ecmascript"]]))

****