Import Python results to PowerBI

dairecoleman / parkrun-app

project for learning app development, hope to make something useful

MIT License

1 stars 0 forks source link

Import Python results to PowerBI #2

Closed dairecoleman closed 3 months ago

dairecoleman commented 3 months ago

Decide how Power BI pulls in tabled info

Considerations: refresh schedule - windows BASH? data source hosted

dairecoleman commented 3 months ago

Connection made.

Scraper script pulls data from html (static for testing purposes) and writes to csv read in by PowerBI parkrun_scraper.py view-source_https___www.parkrun.ie_parkrunner_472100_all_STATIC_HTML.html

Added backtick prefix time column to force PowerBI to read MM:SS data in Post-processing steps added in Power Query Editor