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.
Hello
I want to collect the data from a web page or application which is made using asp.net language. This website has a lot of information in the form of tables which i want to retrieve instead of copying pasting in an excel spreadsheet. How to automate this process. The following screenshot is one of the examples , this page has multiple filters and if i drill down to each row there are further information for each program. I want to gather data from 2021 to current date. Also,, This website can only be accessed by the authorzied users I try to connect through web , it is giving me credentials error.
Hi @Harpreet1405_12 ,
Power BI provides an easy way to import data from web pages using its Web Connector. This feature allows you to connect to a web page and extract tables
Because the website you are trying to access requires authentication, you need to make sure that the Web Connector can handle the login process.Power BI's Web Connector primarily supports basic authentication
For complex data, you may need to utilize the power query editor features
For more details, you can read below document;
Tutorial: Import and analyze data from a webpage - Power BI | Microsoft Learn
The Power Query user interface - Power Query | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It is giving me an token header error
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 |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |