Power BI API

[Harpreet1405_12]

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.

[v-kongfanf-msft]

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.

[Harpreet1405_12]

It is giving me an token header error