Forum Discussion
Power BI: How to Combine Multiple Excel Files from Multiple Websites
Select your query and open Advanced Editor and then add a line in at the top like
( urlToGet as text ) =>and that should turn the query into a function. You will need to replace the existing URL in your query with urlToGet.
Create a new query to get your list of URLs, from a text file or wherever. Add a step to that new query using the Invoke Custom Function button on the Add Column ribbon, and choose the function that you created. Expand the new table column and it should pull in all the data.
You could create a custom function based on the transformation steps you already have but using a URL as a parameter. Then if you pull in a list of URLs from somewhere you can apply the custom function to the column with the URLs in it and then expand the resulting column. That should then have everything combined in the one table.
Hi, sorry not sure how to create the custom function or parameter. I'm guessing I can just create a text file with the list of URL's but not sure how to do that first step on function or parameter. Is this a failry easy process?
Thanks
Select your query and open Advanced Editor and then add a line in at the top like
( urlToGet as text ) =>and that should turn the query into a function. You will need to replace the existing URL in your query with urlToGet.
Create a new query to get your list of URLs, from a text file or wherever. Add a step to that new query using the Invoke Custom Function button on the Add Column ribbon, and choose the function that you created. Expand the new table column and it should pull in all the data.
Brilliant thanks for that - I'll have a go and let you know.