Notifications
Clear all
Power Query
6
Posts
2
Users
0
Reactions
174
Views
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
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
Topic starter
Here is my file...
Thanks for the help!!!!!!!!!!!
Posted : 17/03/2023 12:43 am
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
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
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
