get data from Strava website

[Jeanxyz]

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 website, Power BI will change the url by removing the week_offset condition. How to fix the problem?

original url with data

https://www.strava.com/clubs/xxxx/leaderboard?week_offset=1

Power BI conversion

https://www.strava.com/clubs/xxxx/leaderboard

[PhilipTreacy]

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 · Accepted solution]

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"]]))

****