Skip to main content
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.


How to get table from a subpage of a website which requires user login?

I need to get a Table shown as Expense Summary after finishing data entry of Expenses.

Reason is the stock Summary Report:

  1. lack export capability
  2. lack Amount (in currency of receipt).
  3. lack Condensed Format such as Column Width to Fit Content..
  4. Column cannot be hidden for somebody who has only one Business Purpose.

It will be ideal to copy and paste Table from this WebPage in Edge Browser  into Excel but I need help to do so.

As alternative, I found methods to Import Table from Website but they do not work on said webpage.

I suspect user login is a problem for above methods that work for website that does not require login.

EXAMPLE of what I tried :

  1. Smart Copy (from Edge Browser) into Excel but how to prevent pasted Headers from concatenated string "Sort column ascending"? else, I remove string "Sort column ascending" for Headers

  2. Error Message " This Web query returned no data. To change the query, click OK, click the arrow on the name box in the formula bar, click the name of the eRernaI data range for the Web query, right-click the selection, and thenclick Edit Query. "Webpage containing Table of Summary Report

URL containing Tabular data


Community Support
Community Support

Hi @SunnySchindler ,


There's the web connector in Power Query. Here're the steps:

1. Go to the 'Home' tab.

2. Click on 'Get Data' and select 'Web'.

3. In the 'From Web' dialog, provide the URL of the webpage.

4. The connector will prompt you for access details. Here, you can enter your credentials.


5. Once authenticated, it will display the available data. Select the table you want to import.



Power Query Web connector - Power Query | Microsoft Learn


Best Regards,

Stephen Tao


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Thanks, after more research, it seems that getting data from web via Power Query involves another enhanced security check to reduce user exposure to  secure data and browsing information from intruders and hijackers.

My further questions: 

  1. is this enhanced security check redundant when this Webpage opens with my Edge browser?
  2. how to get Power Query use Edge (default browser) vs IE11?
  3. If PowerQuery depends on browser to get data from website, I turned off site reload in IE mode assuming it is equivalent to disabling "IE Enhanced Security Configuration" option.



Microsoft is discontinuing support for IE11 on Windows 10, therefore SAP Concur needs to transition away from IE11 as well. Please refer to the Internet Explorer Support Policy Change FAQ. View FAQ
Impacts to Analysis/Intelligence (Reporting) are described in the Cognos 11 FAQ. View FAQ

Helpful resources

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


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
Top Kudoed Authors