Using Power Query to Import Data from Web - Passing Date Parameters

Question

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 view the page from my browser, it displays all in 1 table per US day. Because there is a 5-hour difference, it splits it into 2 tables. Does anyone know if there is a way to tell Excel to use the time data from the PC instead of just defaulting to UTC?&nbsp;

riny_van_eekelen · Answer

wsteinbe&nbsp;Would be helpful if you could share the URL.

wsteinbe · Answer

Riny_van_Eekelen&nbsp;&nbsp;https://sportsbook.draftkings.com/leagues/basketball/88670771&nbsp;&nbsp;

sergeibaklan · Answer

wsteinbe&nbsp;
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,&nbsp;

riny_van_eekelen · Answer

wsteinbe&nbsp;Following&nbsp;SergeiBaklan&nbsp;'s suggestion, that could be like in the attached file.

Forum Discussion

Using Power Query to Import Data from Web - Passing Date Parameters

4 Replies

Resources