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

[SunnySchindler]

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

[v-stephen-msft]

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.           

[SunnySchindler]

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