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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Top Solution Authors
Top Kudoed Authors