Forum

power query error o...
 
Notifications
Clear all

power query error on one computer but not other

7 Posts
4 Users
0 Reactions
397 Views
(@ic1uc1)
Posts: 3
Active Member
Topic starter
 

I have spent 3 weeks looking for an answer and a hour with microsoft support to no avail. I got a work book from someone and two of the sheets pull data from a website on the internet. When I hit refresh data button i get an error, "

Unable to open basketball-reference.com/leagues/nba_2024_per_game.html. Cannot download  the  information you requested.

When I take this work book to work and put it on my computer at work the data will refresh with no error. The work book must be ok since it only gives me the error on my home computer. I am running office 2021 64 bit on a Windows 10 home edition. Has anyone else had a problem where you get an error from one computer but not another computer. No one can give me an answer. I reloaded office 2021 and same error.

 
Posted : 12/02/2024 6:00 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi James,

I'm not sure how the data refreshes as that page doesn't exist.

Please supply your file, it's impossible to check anything otherwise.

Regards

Phil

 
Posted : 12/02/2024 7:53 pm
(@ic1uc1)
Posts: 3
Active Member
Topic starter
 

All I know is that it does update with no error at work but not at home. Any insight is greatly appreciated.

 
Posted : 13/02/2024 8:31 am
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
 

James,

I downloaded your file and refreshed both connections without issue.  I am running Win11 and Office 365 Insider.  Sorry, I cannot offer any further help on this.

Alan

 
Posted : 13/02/2024 12:41 pm
(@debaser)
Posts: 837
Member Moderator
 

I can also refresh it on:

M365 on Win10Enterprise

M365 on macOS Sonoma

Office 2019 on Win11 (ARM version in a VM)

 

Perhaps it's a firewall issue at home?

 
Posted : 13/02/2024 2:07 pm
(@ic1uc1)
Posts: 3
Active Member
Topic starter
 

i can add a sheet to this workbook and add my own power query to it. when i hit refresh it will update my sheet but give me errors on other sheets so i do not think it is firewall problem.

 
Posted : 14/02/2024 8:54 am
(@debaser)
Posts: 837
Member Moderator
 

Is it also a web query?

 
Posted : 14/02/2024 9:38 am
Share: