Power Query – Oz Greyhound Trap Stats
There are 3 queries in this workbook.
1. Grab todays greyhound races in Australia or
2. Grab tomorrow's races in Australia
(in both cases I was unable to get the Race number e.g. R1, R2 etc)
3. Table of trap data for each course and distance
Note: the race lists take a while but not too long however, the trap data can take 10-15mins to refresh.
You can design it however you wish
Power Query - Oz Greyhound Trap Stats
- paspuggie48
- Posts: 674
- 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.
- ilovepizza82
- Posts: 506
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
I dont think its working.
When i press "refresh all" i get an error window pop up:
"expression error. The import percentage. Type matches no exports.
Did you miss a module reference?"
When i press "refresh all" i get an error window pop up:
"expression error. The import percentage. Type matches no exports.
Did you miss a module reference?"
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Fine for me. Are you clicking inside the table when refreshing?ilovepizza82 wrote: ↑Thu Nov 25, 2021 8:14 amI dont think its working.
When i press "refresh all" i get an error window pop up:
"expression error. The import percentage. Type matches no exports.
Did you miss a module reference?"
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Here is the version I just updated.!
You do not have the required permissions to view the files attached to this post.
- ilovepizza82
- Posts: 506
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Not sure what im doing wrong here
It updates all of the 2 tabs apart for "oz trap data" me thinks....
It updates all of the 2 tabs apart for "oz trap data" me thinks....
You do not have the required permissions to view the files attached to this post.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Beyond me that one mate, I am sure when Puggsie see's the message he will point you in the correct direction.ilovepizza82 wrote: ↑Thu Nov 25, 2021 8:52 amNot sure what im doing wrong here
It updates all of the 2 tabs apart for "oz trap data" me thinks....
- ilovepizza82
- Posts: 506
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
No prob. Thanks for trying tho.
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Initial thoughts are you selected 'Refresh All'. Generally in any of my PQ's I only state press 'Refresh', because it is specific to the table on the worksheet.
This is because some have dependencies on another Query, so if you select Refresh All there is a possibility it's trying to calculate something before its finished loading into the previous Query.
So, I'd try either selecting Today or Tomorrow worksheet (or one after another) and select 'Refresh' and then move to Oz Trap Data and then select 'Refresh' on that table.
I've just done it and it worked fine.
This is because some have dependencies on another Query, so if you select Refresh All there is a possibility it's trying to calculate something before its finished loading into the previous Query.
So, I'd try either selecting Today or Tomorrow worksheet (or one after another) and select 'Refresh' and then move to Oz Trap Data and then select 'Refresh' on that table.
I've just done it and it worked fine.
- ilovepizza82
- Posts: 506
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Yea i did as you said and it didnt work.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Check the source in the pq list and it should highlight the error in yellow
- ilovepizza82
- Posts: 506
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Just the same error and also it says: "Download did not complete"
Maybe because im using excell 2016 ? Does it require something else ?
Maybe because im using excell 2016 ? Does it require something else ?
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
I am on 2016.ilovepizza82 wrote: ↑Thu Nov 25, 2021 10:00 amJust the same error and also it says: "Download did not complete"
Maybe because im using excell 2016 ? Does it require something else ?
Post the file you are using will take a look.
- ilovepizza82
- Posts: 506
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Thanks. Appreciate it.
You do not have the required permissions to view the files attached to this post.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Sorry mate, it refreshed fine for me....
See the time it just refreshed...
It might be worth checking your settings in the trust center
See the time it just refreshed...
It might be worth checking your settings in the trust center
You do not have the required permissions to view the files attached to this post.
- ilovepizza82
- Posts: 506
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
I noticed i dont have a lot of options you have 4 some reason...
You do not have the required permissions to view the files attached to this post.