Need an Excel Power Query Programmer

Application Overview: Goal on a recurring basis load individual player data categorized by team which is updated on a daily basis to an Excel worksheet. From that data load the worksheet manipulates the daily data (formulas) from which various outcomes from upcoming games can be determined. Successfully application - it all works except ..... The problem: When using power query (Excel 2021) I am able to load all the data from a provider ([login to view URL]): >Date>Import from Web>enter URL (e.g. [login to view URL]"xxx"/[login to view URL] where "xxx" is conditioned for each of the individual teams . . . all 30 of them, i.e Atlanta is [login to view URL]). * Using the query option "Transform Date" I condition the date to the desired format for each team using the categories 1) Team Batting, 2) Team Fielding, & Team Pitching. * Then "Load the Data" to Table and New Worksheet. * I can load all 30 teams in one session (takes approximately 2 hours) and the worksheet them calculates (using the formulas). . . everything works great except . . . * When I attempt to "Refresh" the data the next moring more than half the team date errors "Update cannot complete - a field (column parameter is not recognized). * From what I can tell during "Refresh" Excel goals to the web site but instead of going to the area conditioned by the query navigator it goes to the first data it finds at the top of the worksheet. Maybe I'm stupid but I though when refreshed is was supposed to pull the data as I conditioned using the power query. Is there a fix or is the power query not so powerful . . does it have limits or have I violated some syntax or procedures?