Forum Discussion

jasondrummond's avatar
jasondrummond
Frequent Visitor
4 years ago
Solved

Power BI: How to Combine Multiple Excel Files from Multiple Websites

Hi,   Fairly new to PowerBI but have been successfully combining multiple Excel files stored in a folder successfully.  This has been great as we can just drop a new file in to the folder and all d...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    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.

jasondrummond's avatar
jasondrummond
Frequent Visitor
4 years ago

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

johnt75's avatar
johnt75
Super User
4 years ago

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.

  • jasondrummond's avatar
    jasondrummond
    Frequent Visitor
    4 years ago

    Brilliant thanks for that - I'll have a go and let you know.