Hello Forum-members,
I'm having some hard time to achieve my goals for finishing a project where I need to query approx 500 URLs. Well, I could do things manually for each query, but maybe someone knows a way of repating things, as the queries only differ by the URLs...I would be very greatfull indeed if someone comes up with a solution.
In Detail:
In an Excel Table (or Spreadsheet) I entered a bunch of URL's. As mentioned: each Query from Web works just perfect with Power Query. But I can't figure out how to replace the fixed Url with the URL in a cell in advanced Editor. What I need: Everytime I change a URL in a cell it should exchange the URL in the webquery. Is there a possibility of replacing the URL as String form a cell? This would be part one of the Problem.
Second part: Does anyone know, is there a way to have PowerQuery repeating all things done in a query for each cell containing an URL? That would save me a bunch of time and I guess I'm not the only one interested in a solution here. Any solution tough is very much appreciated.
Thanks for helping me out or giving me a clear indication that it is not possible.
BR
I'm having some hard time to achieve my goals for finishing a project where I need to query approx 500 URLs. Well, I could do things manually for each query, but maybe someone knows a way of repating things, as the queries only differ by the URLs...I would be very greatfull indeed if someone comes up with a solution.
In Detail:
In an Excel Table (or Spreadsheet) I entered a bunch of URL's. As mentioned: each Query from Web works just perfect with Power Query. But I can't figure out how to replace the fixed Url with the URL in a cell in advanced Editor. What I need: Everytime I change a URL in a cell it should exchange the URL in the webquery. Is there a possibility of replacing the URL as String form a cell? This would be part one of the Problem.
Second part: Does anyone know, is there a way to have PowerQuery repeating all things done in a query for each cell containing an URL? That would save me a bunch of time and I guess I'm not the only one interested in a solution here. Any solution tough is very much appreciated.
Thanks for helping me out or giving me a clear indication that it is not possible.
BR