This PQ document scrapes data from http://greyhoundstats.co.uk/index.php
It collates 8 years of Trap data for each course between 2013 - 2020.
(I then calculated the average figures and tabulated them)
It also collates 4 years of data for each Favourite by course and Trap number between 2017 - 2020.
(I then calculated the average figures and tabulated them)
Caveat; some data on the website was missing, so I have had to compensate where possible (possibly due to a course does not exist anymore).
The data updates daily on the website, so you can update the Tables too by going to your Data Tab and clicking on "Refresh".
Power Query - Greyhound Course Trap & Favourite Stats
- paspuggie48
- Posts: 642
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
-
- Posts: 106
- Joined: Tue Feb 14, 2017 1:43 pm
Wish I'd have had this before Wimbledon shut!
Hi,
I downloaded the SSheet and that works fine but when I refresh I get the following message:
'Initialisation of the data source failed
Check the database server or contact admin.Make sure external database is available,and then try the operation again.If you see this message again create a new data source to connect to the database.'
Any suggestions on how to fix this
Or am I doing something wrong
thanks
granty
I downloaded the SSheet and that works fine but when I refresh I get the following message:
'Initialisation of the data source failed
Check the database server or contact admin.Make sure external database is available,and then try the operation again.If you see this message again create a new data source to connect to the database.'
Any suggestions on how to fix this
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
![Surprised :o](./images/smilies/icon_e_surprised.gif)
thanks
granty
- paspuggie48
- Posts: 642
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Not having experienced this before Google says it could be to do with your version of Excel.