Data connection
Getting Data into Power BI
Description: The "Get Data" feature is the starting point for every Power BI project. Power BI is designed to be a universal connector, capable of pulling information from a vast array of sources including local files (Excel, CSV), relational databases (SQL Server), cloud platforms (Azure), and even live web pages.
Why: The quality of your report is entirely dependent on the quality of your data. By establishing a robust connection to a reliable source at the beginning of your workflow, you ensure that your visualizations are accurate and can be easily refreshed when the source data changes.
Common Data Source Types
Power BI categorizes connectors to help you find your data quickly. Here are the most frequently used sources for beginners:
| Category | Examples |
|---|---|
| File | Excel Workbooks (.xlsx), Text/CSV, XML, JSON, and Folders. |
| Database | SQL Server, Oracle, MySQL, and IBM DB2. |
| Online Services | SharePoint Online, Google Analytics, Salesforce, and Dynamics 365. |
Step-by-Step Connection Guide
Follow these steps to import your first dataset into Power BI Desktop:
- Initiate: Click the Get Data icon on the "Home" ribbon.
- Select Source: Choose your specific source type (e.g., Excel) and click "Connect."
- Browse: Locate and select the file or enter the server credentials for your database.
- Navigator: Use the Navigator window to preview your tables or sheets. Check the boxes for the items you want to import.
- Load or Transform: Click Load to bring the data in immediately, or click Transform Data to open the Power Query Editor for cleaning.
Example Scenario
Loading Sales Data:
Imagine you have an Excel file named GlobalSales_2026.xlsx. When you connect, the Navigator will show sheets like Orders and Returns. You select Orders to view columns such as Date, Product, Sales, and Profit. By loading this, you can now begin building a profit-over-time trend chart.
Key Notes
- Load vs. Transform: If your data has messy headers or empty rows, always choose Transform Data. This prevents errors from entering your data model.
- DirectQuery vs. Import: For most beginners, Import is the best choice as it loads a copy of the data into Power BI for faster performance. DirectQuery is used for massive datasets where you want to query the source in real-time.
- Security: Power BI respects the security of the source. If you are connecting to a SQL database, you will be prompted for your credentials to ensure data privacy.
🏋️ Test Yourself With Exercises
Take our quiz on Data connection to test your knowledge.
Browse Quizzes »