Home

Excel Query From Web - Old laptop OK, new PC not OK

%3CLINGO-SUB%20id%3D%22lingo-sub-880612%22%20slang%3D%22en-US%22%3EExcel%20Query%20From%20Web%20-%20Old%20laptop%20OK%2C%20new%20PC%20not%20OK%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880612%22%20slang%3D%22en-US%22%3E%3CP%3EI%20bought%20a%20new%20desktop%20due%20to%20the%20need%20of%20faster%20machine.%20However%2C%20when%20I%20tried%20to%20work%20on%20excel%20to%20get%20data%20from%20a%20website%2C%20table%20is%20not%20showing%20in%20the%20new%20PC.%20In%20the%20query%20Navigator%2C%20it%20only%20shows%20Document%20(Kind%2C%20Name%2C%20Children%2C%20Text).%20This%20is%20kind%20a%20unusual%20for%20me%20because%20i%20didn't%20face%20this%20problem%20in%20my%20old%20laptop.%20Normally%20it%20shows%20document%20and%20other%20table%2Fs%20(0%2C1%2C2%2C...).%20I%20tried%20to%20dig%20on%20data%20source%20setting%20but%20didn't%20succeed.%20I%20tried%20to%20look%20on%20Query%20options%20and%20Access%20Web%20Content%2C%20to%20make%20sure%20old%20laptop%20settings%20and%20new%20desktop%20are%20same%2C%20but%20still%20fail%20to%20show%20the%20other%20tables.%20Also%20tried%20to%20uninstall%2Freinstall%20office%20365%20but%20didnt%20work%20as%20well.%20Appreciate%20someone%20to%20help%20me%20how%20to%20solve%20this%20problem%2C%20I%20attached%20Excel%20query%20Navigator%20screenshot%20from%20old%20laptop%20and%20New%20PC%20for%20better%20understanding%20of%20the%20the%20problem.%20For%20sure%20I%20missed%20some%20setting%20but%20struggling%20where%20to%20dig%20further.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-880612%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Web%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881233%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Query%20From%20Web%20-%20Old%20laptop%20OK%2C%20new%20PC%20not%20OK%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881233%22%20slang%3D%22en-US%22%3E%3CP%3EI%20tried%20to%20use%20Power%20BI%20as%20well%2C%20but%20gave%20me%20same%20result.%20New%20PC%20unable%20to%20fetch%20other%20tables%2C%20while%20old%20laptop%20is%20working%20ok%20fetching%20all%20tables%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBtw%2C%20old%20PC%20OS%20is%20Windows%2010%20Home%20and%20new%20PC%20is%20Windows%2010%20Pro%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881551%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Query%20From%20Web%20-%20Old%20laptop%20OK%2C%20new%20PC%20not%20OK%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881551%22%20slang%3D%22en-US%22%3E%3CP%3EAdditional%20details%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FUnable-to-Connect-to-Web-Source-With-Credentials-in-Power-Query%2Fm-p%2F881457%2Fhighlight%2Ffalse%23M41021%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FUnable-to-Connect-to-Web-Source-With-Credentials-in-Power-Query%2Fm-p%2F881457%2Fhighlight%2Ffalse%23M41021%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
lealpermalino
Occasional Contributor

I bought a new desktop due to the need of faster machine. However, when I tried to work on excel to get data from a website, table is not showing in the new PC. In the query Navigator, it only shows Document (Kind, Name, Children, Text). This is kind a unusual for me because i didn't face this problem in my old laptop. Normally it shows document and other table/s (0,1,2,...). I tried to dig on data source setting but didn't succeed. I tried to look on Query options and Access Web Content, to make sure old laptop settings and new desktop are same, but still fail to show the other tables. Also tried to uninstall/reinstall office 365 but didnt work as well. Appreciate someone to help me how to solve this problem, I attached Excel query Navigator screenshot from old laptop and New PC for better understanding of the the problem. For sure I missed some setting but struggling where to dig further.

2 Replies

I tried to use Power BI as well, but gave me same result. New PC unable to fetch other tables, while old laptop is working ok fetching all tables

 

Btw, old PC OS is Windows 10 Home and new PC is Windows 10 Pro

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies