08-05-2023 05:07 AM
This report contains data about my home Parkrun in the UK, im still working on getting the datasource to refresh automatically as its automatically generating a web URL to download the results from the web.
ill get round to it at some point, info about my local Parkrun is here course | South Shields parkrun
the latest results are published here - results | South Shields parkrun
i "scrape" the results from here - results | South Shields parkrun
Link to .pbix file - https://bit.ly/3rYESRw
sorry for the delay, ive added a bitly link to the pbix file in my description, it may be a little messy and im doing quite a bit of work to try and generate a primary key for runners, essentially the runners barcode number is not published in the results so i need to create a dummy primary key, there are commonly duplicate names especially with people who register with dummy names (probably for data privacy) so i do a bit of work to split out the names, how many parkruns they have completed at my home parkrun and the number they have completed all time and combine these together to try and make a primary key... it doesnt work all of the time so there are some errors and this may be compounded at other events.
if you make any improvements or have any suggestions for improvements let me know, it does take a bit of time to refresh the data and i still havent updated it to run from the powerbi service yet but the refresh can be ran manually ive just updated it today
i also think id like to use the new dynamic lables to add in the time as hh:mm:ss rather than decimal time but i need to find some time from somehwere to do this in the future
hope you like having a look at my messy pbix file 🙂