Power BI API

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.