I'm new to Power query. I'm using it to pull some sports data from Fangraphs into my sheet. I have variety of custom tables made on Fangraphs - Batters vs LHP, Batters v RHP, etc. I'm trying to create a unique query for each. I make my 9 queries using New Query>From other sources>From web. All create fine. The issue is that when I try to refresh, I start getting Expression errors. It seems as though whatever the most recently used URL is, is what Excel tries to use for ALL of the queries. So, the Batter Vs LHP table doesn't find ERA if the Pitcher's table was the most recent URL used. What is causing this? When I go into Data source settings, should I be seeing 9 different URLS for my 9 queries here? Or is this settings page unique to each query?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Power Queries all using the same source URL, even though I enter unique URLs for each...
- Thread starter J187
- Start date
Similar threads
- Question
- Question
- Solved
