The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hello,
I would like to connect to my strava-account and get all my data of my activities.
I'm really using Power BI a lot lately and I like to practice more for usage at work and it would be great to do it with a huge database of my cycling activities.
Any help would be great!
Solved! Go to Solution.
I think this is exactly what you need: https://www.kasperonbi.com/building-the-power-bi-strava-data-connector/
Use Flink to download Strava Activity Data
@pierrebijl For a simpler solution than building the Power BI-Strava Connector is to download Excel/CSV from https://flink.run
One can donwload All or Custom data fields of activities and also connect to Googe drive, its a good Dashboard site compatible with Strava.
One can also try connecting to GDrive and use Google Data studio for live activity Dashboard experience.
Thanks.
Thanks for your reply! But I don't think this is the right way. Essence of Power BI I think is easy quick access to your data. The excel extract from Strava is very slow and limited on a data perspective (takes over an hour before it is send by email). The connector is much easier, update takes seconds and the data is more specific, also on single rides. Only problem is Strava, it worked for a long time. But they changed something a few months ago why the connector had to be made again on a different coding. Further it worked awesome.
I think this is exactly what you need: https://www.kasperonbi.com/building-the-power-bi-strava-data-connector/
I've done tgis with the Strava-API and a web connection in Power BI. Pretty straightforward, good use of M in translating JSON data to tables.
Hi @pierrebijl,
I am not familiar with Strava.
According to this submitted idea, Power BI doesn’t import gpx files from Strava properly. However, based on my research, there are some workarounds for this issue.
For example, you can consider to convert GPX files from Strava to CSV file following the instructions in this blog, then import the CSV file to Power BI Desktop, create report and publish it to Power BI Service.
Another method is to connect Power BI to your Strava account using the Strava API and JSON. For more details, please review this blog.
Thanks,
Lydia Zhang
Hi @pierrebijl,
I would recommend you vote the above idea as there is no easy method to directly connect to the database in Power BI.
And personally, I would suggest you convert the files to CSV and conect to the CSV from Power BI. Regarding to the API code issue, you can contact the author of the above blog.
Thanks,
Lydia Zhang
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.