Power Query - Oz Greyhound Trap Stats

Post Reply
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Power Query – Oz Greyhound Trap Stats

AUS Greyhound Trap Stats.xlsx

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)

Screenshot 2020-12-11 143000.png


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.

Screenshot 2020-12-11 142941.png

You can design it however you wish ;)
You do not have the required permissions to view the files attached to this post.
User avatar
ilovepizza82
Posts: 490
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?"
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

ilovepizza82 wrote:
Thu Nov 25, 2021 8:14 am
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?"
Fine for me. Are you clicking inside the table when refreshing?
User avatar
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.
User avatar
ilovepizza82
Posts: 490
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....
You do not have the required permissions to view the files attached to this post.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

ilovepizza82 wrote:
Thu Nov 25, 2021 8:52 am
Not sure what im doing wrong here
It updates all of the 2 tabs apart for "oz trap data" me thinks....
Beyond me that one mate, I am sure when Puggsie see's the message he will point you in the correct direction.
User avatar
ilovepizza82
Posts: 490
Joined: Thu Nov 02, 2017 3:41 pm
Location: Sewers
Contact:

No prob. Thanks for trying tho.
User avatar
paspuggie48
Posts: 611
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.
User avatar
ilovepizza82
Posts: 490
Joined: Thu Nov 02, 2017 3:41 pm
Location: Sewers
Contact:

Yea i did as you said and it didnt work.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

ilovepizza82 wrote:
Thu Nov 25, 2021 9:32 am
Yea i did as you said and it didnt work.
Check the source in the pq list and it should highlight the error in yellow
User avatar
ilovepizza82
Posts: 490
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 ?
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

ilovepizza82 wrote:
Thu Nov 25, 2021 10:00 am
Just the same error and also it says: "Download did not complete"
Maybe because im using excell 2016 ? Does it require something else ?
I am on 2016.

Post the file you are using will take a look.
User avatar
ilovepizza82
Posts: 490
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.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

Sorry mate, it refreshed fine for me....
Screenshot 2021-11-25 114154.png
See the time it just refreshed...

It might be worth checking your settings in the trust center
Screenshot 2021-11-25 114354.png
You do not have the required permissions to view the files attached to this post.
User avatar
ilovepizza82
Posts: 490
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.
Post Reply

Return to “Excel Power Query”