Forum Discussion
Unable to Connect to Web Source With Credentials in Power Query using new PC (Power BI and MS Excel)
I bought a new desktop due to the need of faster machine. However, when I tried to work on Power BI 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. Privacy settings and levels are also the same.
I tried to use EXCEL as well and it has the same problem.
Appreciate someone to help me how to solve this issue, I attached 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, or missing some patch. PBI version are both the latest as well as MS Excel 365, only difference is their OS. Old laptop has WIndows 10 HOME and new PC has Windows 10 PRO..
New PCOld laptop
3 Replies
- AnkitBISolution Sage
Check if Extract Table using Example works for you
https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.- lealpermalinoRegular Visitor
I did that as well, but PBI just keeps on loading.. See below snapshot
- lealpermalinoRegular Visitor
PBI navigator snapshots. (Attachment in my initial post are from EXCEL)PBI_NewPCPBI_OldPC