get data web with calendar options

[atapia197]

Hi all, here is the challenge 😉

I am getting data web from booking.com, using for example this url:

https://www.booking.com/hotel/es/marina.es.html?label=gen173nr-1FCAEoggJCAlhYSDNYBGhGiAEBmAEKwgEDYWJ...;checkin=2018-05-25;checkout=2018-05-26;ucfs=1;srpvid=9ac6615f846900ac;srepoch=1527256257;highlighted_blocks=9729201_90772511_0_0_0;all_sr_blocks=9729201_90772511_0_0_0;bshb=2;room1=A%2CA;hpos=1;hapos=1;dest_type=city;dest_id=-373226;srfid=5e48963f46da5da1c0e069a14222ace2b6112768X1;from=searchresults;hptv=do#hotelTmpl

PowerBI returns a table with the rates of this Hotel for these dates: checkin=2018-05-25;checkout=2018-05-26

The question is: If I have an excel with X urls with different checkin&checkout dates, is there any way to merge the different tables of each url, with a process like the Get Data Folder (creating a parameter, function and example file)?

Thanks a lot.

[v-yulgu-msft · Accepted solution]

Hi @atapia197,

I would suggest you create date parameters so that you could dynamically select data range.

Dynamic date in web source

Is it possible to dynamically update the source URL with Power Query ?

However, unfortunately, query patameter doesn't support multiple-selection right now. We can only choose a single value to filter data source. If the wanted "checkin" and "checkout" dates are not continual, you may need to load X urls with different checkin&checkout dates one by one, then, append them in Query Editor mode.

Regards,

Yuliana Gu