Forum Discussion
wsteinbe
Feb 25, 2022Copper Contributor
Using Power Query to Import Data from Web - Passing Date Parameters
I am currently pulling data from a website that splits data into different tables by day. The problem is when I use Power Query to link to the data from the web page, it uses the UTC date. When I vie...
Riny_van_Eekelen
Feb 25, 2022Platinum Contributor
wsteinbe Would be helpful if you could share the URL.
wsteinbe
Feb 26, 2022Copper Contributor
- Riny_van_EekelenFeb 27, 2022Platinum Contributor
wsteinbe Following SergeiBaklan 's suggestion, that could be like in the attached file.
- SergeiBaklanFeb 26, 2022Diamond Contributor
I guess website takes Server Time (actually your computer time)
and split events on two tables, Today and Tomorrow for your local time. Perhaps the easiest append one table to another and return result,