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

%3CLINGO-SUB%20id%3D%22lingo-sub-3213654%22%20slang%3D%22en-US%22%3EUsing%20Power%20Query%20to%20Import%20Data%20from%20Web%20-%20Passing%20Date%20Parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3213654%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20pulling%20data%20from%20a%20website%20that%20splits%20data%20into%20different%20tables%20by%20day.%20The%20problem%20is%20when%20I%20use%20Power%20Query%20to%20link%20to%20the%20data%20from%20the%20web%20page%2C%20it%20uses%20the%20UTC%20date.%20When%20I%20view%20the%20page%20from%20my%20browser%2C%20it%20displays%20all%20in%201%20table%20per%20US%20day.%20Because%20there%20is%20a%205-hour%20difference%2C%20it%20splits%20it%20into%202%20tables.%20Does%20anyone%20know%20if%20there%20is%20a%20way%20to%20tell%20Excel%20to%20use%20the%20time%20data%20from%20the%20PC%20instead%20of%20just%20defaulting%20to%20UTC%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3213654%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3213788%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Power%20Query%20to%20Import%20Data%20from%20Web%20-%20Passing%20Date%20Parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3213788%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1317851%22%20target%3D%22_blank%22%3E%40wsteinbe%3C%2FA%3E%26nbsp%3BWould%20be%20helpful%20if%20you%20could%20share%20the%20URL.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3216544%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Power%20Query%20to%20Import%20Data%20from%20Web%20-%20Passing%20Date%20Parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216544%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsportsbook.draftkings.com%2Fleagues%2Fbasketball%2F88670771%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsportsbook.draftkings.com%2Fleagues%2Fbasketball%2F88670771%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217042%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Power%20Query%20to%20Import%20Data%20from%20Web%20-%20Passing%20Date%20Parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1317851%22%20target%3D%22_blank%22%3E%40wsteinbe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20website%20takes%20Server%20Time%20(actually%20your%20computer%20time)%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20268px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351454iBD83F8D75FCAAAF7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20split%20events%20on%20two%20tables%2C%20Today%20and%20Tomorrow%20for%20your%20local%20time.%20Perhaps%20the%20easiest%20append%20one%20table%20to%20another%20and%20return%20result%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217754%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Power%20Query%20to%20Import%20Data%20from%20Web%20-%20Passing%20Date%20Parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1317851%22%20target%3D%22_blank%22%3E%40wsteinbe%3C%2FA%3E%26nbsp%3BFollowing%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B's%20suggestion%2C%20that%20could%20be%20like%20in%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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? 

4 Replies

@wsteinbe Would be helpful if you could share the URL.

@wsteinbe 

I guess website takes Server Time (actually your computer time)

image.png

and split events on two tables, Today and Tomorrow for your local time. Perhaps the easiest append one table to another and return result, 

@wsteinbe Following @Sergei Baklan 's suggestion, that could be like in the attached file.