Forum Discussion
Looping Power query
Hello Ronny75 ,
you can create a table with columns for start- and end-date and then one row for each page.
Then add a column to this table that calls a function doing the extraction. When expanding that column you'll receive one table with all your data consolidated.
I've described the general method here: Web Scraping 2: Scrape multiple pages at once and refresh in Power BI service – The BIccountant
Community ChampionHello Ronny75 ,
you can create a table with columns for start- and end-date and then one row for each page.
Then add a column to this table that calls a function doing the extraction. When expanding that column you'll receive one table with all your data consolidated.
I've described the general method here: Web Scraping 2: Scrape multiple pages at once and refresh in Power BI service – The BIccountant
Thanks alot for that.
Had some problems first, since my parameters where Date and not Text i had to choose to get "Column name" instead of Date when i did the "Invoke Custom Function" in my Months Table but when i found that it worked like a charm.
Very nice solution, thanks for the help!
