Strange Power Query Issue

What does your Mcode look like? Maybe you should upload your file so it can be investigated.

The MCode can be viewed via the Advanced Editor button on the ribbon in the PQ Editor.

But that does not appear to be the issue here. I can see all the tables available.

How EXACTLY (step-by-step) are you going about the web query?

I did:

1. Data ribbon > From Web.
2. Paste URL: https://www.baseball-reference.com/l...pitching.shtml > OK.
3. Web View reveals 30 HTML tables (including the two you are intersted in).

It looks like you use the Chrome browser - is that your default browser? I wonder if that might be it. I am using Firefox - maybe try a different default browser?

FYI--I use Chrome and Norton Private Browser and I get all tables with both of those. I wonder if your browser is corrupted and needs to be reinstalled or maybe your version of Excel is corrupted and needs to be reinstalled. Your profile indicates you are using XL2021. Is this a desktop version or an on line version of excel? I am using O365 Desktop and I will assume (careful Alan) that Ali is using the same.

Yes, Ali is, Alan! But I don't believe there's an online version of any version other than 365.

@IdabaMalouki
Curious now. Does the same thing happen for you when you select batters?


Also, have you cleared your browser cache lately? Don't really know if this will make a difference or not.

Are you asking me?

@Ali
Sorry, but I forgot to address it to IdabaMalouki .
Alan

It's AI driven web query. A feature that is still rolling out. Production rollout started on Mar 30.
You can find it in comment section of the article that announced it.
https://techcommunity.microsoft.com/...r/ba-p/3963465

I can confirm I don't have it on mine yet.

Also it requires MS365 subscription.

Subscribe instead going forward.

@CK76 Thanks for the news. I guess I should read about the updates more often.

@IdabaMalouki My 365 subscription is $50/year. That gets me 7 years using your $350 which is longer than I have ever waited to upgrade in the past. I think subscription with Beta Channel is the way to go to have the most up to date functionality. Just my opinion.

Only Microsoft can answer that business decision question.

They are different products: what you have is a one-off paymant standalone product, whereas 365 is a subscription product that will alwyays have the most up-to-date functions and features. If you want to be at the cutting edge without having to pay for a new product, then 365 is the way to go. Yes, you have to pay again: a personal subscription (one-user only) will cost around $70 a year; a family subscription (for up to six users) will cost around $100 a year. Of course, you have to continue to subscribe to maintain access to it. It's whatever suits you better, really. If you can make use of the family offering, then that is exceptionally good value, in my view - there are three of us using mine on multiple devices.

https://www.microsoft.com/en-us/micr...saAqC6EALw_wcB

That's a very kind thing to say. We do have a fair number of 'takers' here who can't even be bothered to acknowledge the help offered, let alone say 'thanks' for it, so messages like this are very heartening indeed. Glad to have helped.

Happy to have helped. Thanks for the Rep and kind comments.