Connecting to Online Services (APIs, Web Data) in Power BI
Introduction
Power BI allows users to integrate real-time
data from online sources, such as APIs, web pages, Google Sheets,
SharePoint, and cloud-based databases. This enables businesses and analysts
to fetch up-to-date external data without manually downloading and importing
it.
🔹 Why
Connect to Online Services?
✔️ Automate data extraction from web-based sources.
✔️ Access real-time or frequently updated data.
✔️ Merge external data with internal datasets.
✔️ Eliminate manual effort and errors in data
updates.
Power BI offers multiple ways to connect with online
data sources, including REST APIs, JSON data, and web
scraping from websites.
Step-by-Step Methods to Connect Power BI to Online Services
Case
Study 1: Connecting to a Web Data Source (Web Scraping from Websites)
Example:
Importing data from a publicly available website, such as
COVID-19 statistics, stock
prices, or weather reports.
Steps to
Connect to a Website (Web Scraping)
1️ Open Power BI Desktop.
2️ Click on "Home"
→ "Get Data" → "Web".
3️ In the URL
box, enter the website URL containing the data.
- Example: https://www.worldometers.info/coronavirus/ (for COVID-19 statistics).
4 Click OK, and Power BI will analyze the webpage structure.
5️ A Navigator window will appear, showing available tables.
6️ Select the table or list containing the required data.
7️ Click Load to import the data into Power BI.
8️ If needed, use Power Query Editor to clean and transform the data.
9️ Click Close & Apply to finalize the dataset.
Second Url
0 टिप्पण्या
कृपया तुमच्या प्रियजनांना लेख शेअर करा आणि तुमचा अभिप्राय जरूर नोंदवा. 🙏 🙏