Power Query - Oz Greyhound Trap Stats

[paspuggie48]

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

[ilovepizza82]

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?"

[Realrocknrolla]

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?

[Realrocknrolla]

Here is the version I just updated.!

[ilovepizza82]

Not sure what im doing wrong here
It updates all of the 2 tabs apart for "oz trap data" me thinks....

[Realrocknrolla]

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.

[ilovepizza82]

No prob. Thanks for trying tho.

[paspuggie48]

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.

[ilovepizza82]

Yea i did as you said and it didnt work.

[Realrocknrolla]

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

[ilovepizza82]

Just the same error and also it says: "Download did not complete"
Maybe because im using excell 2016 ? Does it require something else ?

[Realrocknrolla]

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.

[ilovepizza82]

Thanks. Appreciate it.

[Realrocknrolla]

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

[ilovepizza82]

I noticed i dont have a lot of options you have 4 some reason...