Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
I need to get a Table shown as Expense Summary after finishing data entry of Expenses.
Reason is the stock Summary Report:
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 :
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
URL containing Tabular data
https://eu2.concursolutions.com/nui/expense/report/FD2D8322FBD44B6CBA5C
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:
APPENDIX
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
13 | |
12 | |
12 | |
12 |