Forum Discussion
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 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
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"]]))
****
2 Replies
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
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"]]))
****
