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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply

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. https://www.exceldemy.com/import-table-from-website-to-excel/ 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

https://eu2.concursolutions.com/nui/expense/report/FD2D8322FBD44B6CBA5C

 

2 REPLIES 2
v-stephen-msft
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.

vstephenmsft_0-1701761806926.png

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.

 

APPENDIX

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

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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