Accessing imported data from a website powered by Power BI will depend on the way it's serving the data. The best practices will be:
1. Using Power BI REST API (If You Have Access)
In case it's company-hosted, use the Power BI REST API to get dataset information, reports, and dashboards. Here's how to do it:
Register Azure AD App for authentication.
Call Power BI REST API to retrieve data from reports or datasets.
Export report visuals into JSON or image formats to analyze it.
2. Direct Database Connection (Where It's Possible)
If the website drives its information from a database like SQL Server or Azure Synapse, check whether you can get read access to the source database or not.
Connect directly to query using Power BI Desktop or SQL.
3. Web Scraping (If No API or Direct Access)
If the website exposes data only but does not provide direct access to the source, web scraping tools like Python (BeautifulSoup, Selenium) can scrape all displayed data based on the URL definition.
Scraping Power BI visuals embedded in web pages (through an iframe or JavaScript rendered) is difficult and may require automated browser work.
4. Compliance and Ethical
Make sure that you have legally authorized means of accessing the data (see the Terms of Service on the website).
Do not scrape data that is protected or compromised confidentially without prior permission.
If not certain, contact the data owner or use authorized APIs to access it.
