Microsoft Excel Training: Scraping NBA player data from Basketball-Reference with Power Query (1)

The code to use for Power Query is:

let
QryParam = Table.FirstValue(Excel.CurrentWorkbook(){[Name="BBallRefURL"]}[Content]),
Source = Web.Page(Web.Contents(QryParam)),
Data0 = Source{0}[Data]
in
Data0

[_Manimal_]

Let me tell you, you are a lifesaver, this really saved me a tedious daily task i click its done, thanks

[KEWL]

Hey I really enjoyed the video! Could you possibly make a video with creating a sql database for NBA players stats?

[drewwoods]

I keep getting "Expression.Error: We cannot convert the value to type Text" when I try to change the code to use for Power Query. Any ideas for what I am doing wrong? I have been looking for a straightforward tutorial for this for a long time. This is gold!!!

[dropthatshi]

Awesome video thanks so much!! If I wanted to use vba to take the user input for a player (eg Lebron James) then build the url through concatanating like youve done here to get the link to his 2023 gamelog, could I then use that created URL to call a query and have his game log imported to a new worksheet? How would I get vba to import the data from that URL?

[andypappas]

Any way I can contact you to ask more questions about importing basketball and football stats?

[traviswilliams]

Do you happen to know a website that we can pull nba spreads and overs in from that will update? I can't find a website table that will pull into excel

[stevenhymel]

is there away to get the alldata to automatically update to the date you search instead of coping an pasting from new data?

[leonardofalconi]

Is that possible to do in Google Sheets? I would like have a shared sheet with s friend

[cyprusmorris]

So with this the excel sheet with update by itself?

[GARDIINC]

is this free or is this something i have to pay for?

[haydenreed]

Hi - great video. Massive time saver no doubt!!
I have tried making some adjustments to the data that is pulled but it then seems to disable to ability to change date and refresh the new table.
I am wanting to change things like column headings, replace null with 0, replace null with home, replace @ with away, and change values to numbers rather than text... Just a couple of small changes. Any idea why it doesn't allow for the update on the date following these changes???
Thanks!