Scrape a web-table with custom search inputs

[Anders1]

Hi,

Im struggling to scrape this website:

http://fishpool.eu/fishpool/#/public/details

No problem to scrape this table, but i want to edit the search fields to show data from week 1 to 52 and year from 2013 to 2019. i can't figure this out. Is there a easy way doing this? There is a option for exporting to excel (xls) and i got this working, but to get power bi to accept xls-data i had to install another access datbase engine on my computer, and this wont work if i want to add a scheduled refresh from power bi service.

Any help on this would be appreciated 🙂

[v-juanli-msft]

Hi @Anders1 

Actually, i am unable to get data from your link. 

Since you said "No problem to scrape this table", assume you can get data from the web link with Power BI Desktop,

then to get limit data as you expected, you could create query parameter in Edit queries.

Please see more detials here:

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4

https://www.biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-par...

Creating Dynamic Parameters in Power Query

If you have trouble implementing this, please share code in Advanced editor with me.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.