Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
lealpermalino
Regular Visitor

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 PCNew PCOld laptopOld laptop

3 REPLIES 3
AnkitBI
Solution Sage
Solution 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.

I did that as well, but PBI just keeps on loading.. See below snapshot

PBI - New_PC - add table using examples.PNG

PBI navigator snapshots. (Attachment in my initial post are from EXCEL)PBI_NewPCPBI_NewPCPBI_OldPCPBI_OldPC

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors