Power query problem

[richarddawson]

I am relatively new to Power Query, but whenever I enter a particular site and "Load" the screen I want all I get is
View attachment 43831
and nothing I do takes me any further.
Can anyone help, please?

 

[jorismoerings]

Hi,

I saw this thread a few times in the unaswered threads but never opened it.
You don't give us to much to go on other than a clear question Help,please.
So we need some clarification hence these questions:

1. Could you share which site you trying to load.
2. is this the only step in your query or did you do other steps as well. If there are other steps Copy the steps from the advanced editor and insert them in the thread.
3. what's the desired result?

Hope this helps.

 

[richarddawson]

Hi Joris,

Sorry for the delay in answering your post, for which I thank you.

I am looking at

Sports Spread Betting | Sports Betting - Spreadex

Sports spread betting with Spreadex, the sports spread betting experts since 1999.

www.spreadex.com

If you then click "Tennis" (as an example) and then go Ctrl+A much of the screen will be highlighted, but the betting odds will not be. That is what I am trying to get, because, of course, I can easily copy and paste everything else.

Cheeers, Richard

 

[GraH]

Seems you need a login to the site... I'm not sure what you could retriever from it without login. Maybe you could call an API from the site and have an XML or Json script to get to the data. At first glance this is not a PQ I'd advice starters to try.
For the record, I think I'm relatively good at PQ, but pulling data from the web is something I never need to do.

 

[richarddawson]

Thanks GraH, good advice, I think.