Power Query - Error Messages

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

If anyone gets any Power Query error messages or general issues maybe one can post it in this thread?
User avatar
paspuggie48
Posts: 674
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

All queries should work regardless of the Excel version you have.

Generally, many issues are around permissions which is down to Privacy settings.

Go to the 'Data Tab'
Click on the arrow of the 'Get Data' icon
Select 'Query Options'

On the Query Options window;
Select 'Privacy'
You may need to select "Always ignore Privacy Level settings"

PQerror.png
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2208
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

ok i'll be the first in this thread.
how do i fix this error on your latest dog data sheet?
Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
paspuggie48
Posts: 674
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

MemphisFlash wrote:
Tue May 14, 2024 3:52 pm
ok i'll be the first in this thread.
how do i fix this error on your latest dog data sheet?

Capture.PNG
Didn't we have something similar recently (?) and although not entirely resolved I had to assume it was the version of Excel. I know way back when I was trying to access someone's PQ it was because their version was later than mine.

A thread with similar issue is here https://community.fabric.microsoft.com/ ... it%20work.

Not sure why it appears though as I did nothing special except Get Data > from Web.

Try it for yourself from scratch and use that URL I did for Stellabot https://www.timeform.com/greyhound-raci ... arne/86731
Ashover
Posts: 10
Joined: Fri May 31, 2019 4:56 am

Getting this error scraping https://www.thegreyhoundrecorder.com.au/
You do not have the required permissions to view the files attached to this post.
User avatar
paspuggie48
Posts: 674
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Ashover wrote:
Thu May 16, 2024 9:12 am
Getting this error scraping https://www.thegreyhoundrecorder.com.au/
Your answer is written in your screenshot "access to resource is forbidden"

You didn't specify any particular webpage, meeting or whatever, so I tried a number of their webpages and received the same message.

So, it's a no no from them to get any data via Power Query.
Post Reply

Return to “Excel Power Query”