Forum Discussion
get data web with calendar options
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-1FCAEoggJCAlhYSDNYBGhGiAEBmAEKwgEDYWJuyAEU2AEB6AEB-AELkgIBeagCBA;sid=ad5bdc9f752a31a45da242f60929b3f9;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.
Hi atapia197,
I would suggest you create date parameters so that you could dynamically select data range.
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
1 Reply
- v-yulgu-msft
Microsoft Employee
Hi atapia197,
I would suggest you create date parameters so that you could dynamically select data range.
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