Import Data into Power BI
Learn how to efficiently import and manage data from various sources into Power BI. This course teaches you how to streamline your data analysis and reporting processes.
What you'll learn
Before you can derive insights from your data in Microsoft Power BI, you first need to import that data. In this course, Import Data to Power BI, you’ll gain the ability to efficiently import and manage data from various sources into Power BI. First, you’ll explore the "Get Data" feature and how to use the search function to locate specific data connectors. Next, you’ll discover how to establish a connection to SQL databases and import data from Excel files. Finally, you’ll learn how to access web data sources and use DirectQuery for large datasets. When you’re finished with this course, you’ll have the skills and knowledge of Power BI data import options needed to streamline your data analysis and reporting processes.
Table of contents
- Introduction 0m
- Overview 0m
- About Microsoft Fabric 1m
- Import Data from Microsoft Excel 2m
- Import and Analyze Data from the Web in Power BI 1m
- Regarding Power BI Data Refresh 2m
- Demo: Prepare Workbooks for Data Import 5m
- Demo: Import Excel Workbooks from SharePoint and OneDrive 3m
- Demo: Experiment with the Web Connector 3m
- Demo: Configuring Semantic Model Refresh in the Power BI Service 4m
- Conclusion 1m
About the author
Timothy Warner is a Microsoft Most Valuable Professional (MVP) in Cloud and Datacenter Management who is based in Nashville, TN. His professional specialties include Microsoft Azure, cross-platform PowerShell, and all things Windows Server-related. You can reach Tim via Twitter (@TechTrainerTim), LinkedIn or his blog, AzureDepot.com.