Extracting data from a site that employs Power BI for visuals is difficult because data gets loaded dynamically through APIs rather than being present in the page's HTML. Such data may not be scraped with the traditional methods of web scraping.
Possible Solutions:
Verify if a Public API Exists: Many sites using Power BI get their data through APIs. Inspect the network requests in your browser's Developer Tools (F12 > Network tab) to see if an API is being called. If it is, connect Power BI directly to the API using Power Query (Web Connector) for your needs.
Use the Power BI Embedded API—If the site uses Power BI Embedded, it may be possible to extract data using the Power BI REST API (which requires authentication and permissions). This is more feasible if you own the report.
Extract Data from Browser Dev Tools—Otherwise, open the XHRequests in the browser's Developer Tools and produce any response that it requests. Many times, the data gets loaded in JSON format and can be extracted with the help of a custom Power Query Script.
Use Selenium or Power Automate—These can be used when you need automation. For instance, you can use Selenium(Python) or Power Automate Desktop to extract the table data and simulate user actions.
