Notifications

Clear all

Error connecting Excel to a website

Power Query

Last Post by Philip Treacy 2 years ago

6 Posts

2 Users

0 Reactions

188 Views

RSS

lea cohen

(@usb)

Posts: 244

Honorable Member

Topic starter

Hi, I am connecting the excel to this site -
 https://calendar.2net.co.il/parasha.aspx 
It's in Hebrew (I hope you don't mind...) 
I already created a query linked to the site several months ago
 and now I click refresh and an error message pops up -
[DataFormat.Error] The server or Proxy the was not found

And when I create a new query, an error message appears
 the server or Proxy the - was not found.
I didn't understand the error message.
How can this be fixed? Thanks

Posted : 16/03/2023 10:59 am

Philip Treacy

(@philipt)

Posts: 1629

Member Admin

Hi Lea,

I don't have any problem loading a table off that website using a new query - see attached file.

Can you please supply your file so we can examine it.

Regards

Phil

Posted : 16/03/2023 7:57 pm

lea cohen

(@usb)

Posts: 244

Honorable Member

Topic starter

Here is my file...
Thanks for the help!!!!!!!!!!!

Posted : 17/03/2023 12:43 am

Philip Treacy

(@philipt)

Posts: 1629

Member Admin

Hi Lea,

I'm not getting an issue I'm afraid. When I run your query I get 59 rows loaded into excel.

Regards

Phil

Posted : 18/03/2023 11:05 pm

lea cohen

(@usb)

Posts: 244

Honorable Member

Topic starter

Interesting, because I have an error.
So what does the error mean -

 the server or Proxy the - was not found.?

Posted : 20/03/2023 3:54 am

Philip Treacy

(@philipt)

Posts: 1629

Member Admin

Hi Lea,

I don't know. That error message does not make any grammatical sense, are you translating it from Hebrew? It would make sense if it read 'the server or proxy was not found'.

In which case I'd guess it was basically saying it can't find the website. However I don't know why it mentions a proxy. How is your network set up? Are you using proxy servers?

Regards

Phil

Posted : 20/03/2023 8:00 pm