Power Query - Parameter not working

Hi,

I run the query and a parameter box opens where I want to be able to enter a team abbreviation to bring up the statistics for that team. I've created a parameter called club. I've attached the query. Can anyone show me what I'm doing wrong to bring up this error? Thank you


An error occurred in the ‘’ query. DataSource.Error: The remote server return an HTTP status code '404' when trying to access 'https://www.baseball-reference.com/teams/club/2017.shtml'.
Details:
DataSourceKind=Web
DataSourcePath=https://www.baseball-reference.com/teams/club/2017.shtml
Url=https://www.baseball-reference.com/teams/club/2017.shtml

Please Login or Register  to view this content.

did you check this url in browser?

Page Not Found (404 error)

The question I have is how to be able to enter the parameter and have it change the address from.

https://www.baseball-reference.com/t...lub/2017.shtml

Then if the parameter is atl

Have it change to

https://www.baseball-reference.com/teams/atl/2017.shtml

check this one
update list because there is only a few: ARI,ATL,BAL,BOS,CHC,CHW,CIN,COL,DET

I am looking to get the small table to show up as a value within my workbook. I have done this with other sites and able to pull up the data but for some reason I cannot get this table to pull the data within Excel. The second URL that you tried is irrelevant and I removed it to prevent any confusion. Any help so that I can pull this data would be very helpful and appreciated.

@kingsdime29x

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.