If you want to know how to make Power BI import data from Excel, read this post. In Power BI, there are several sources of getting data and the most popular of them is Excel. Besides it, text files, .txt or .csv, SQL, Azure, SAP and Sales Force databases are widely used.
Knowing how to make Power BI upload Excel file is critical. Because, it is the most popular information storage software on the planet. Companies that work in several segments use Excel to make their controls.
In this post, we will guide you through the necessary steps to learn how to connect Excel to Power BI. So, follow the steps below and say in the comments if you were able to export an Excel spreadsheet to Power BI.
How to import Excel workbooks into Power BI Desktop
To connect Excel to Power BI and be able to process the data, follow the steps below:
- Click the Home tab.
- Find the Data group.
- Click the Excel Workbook button.
- Select the Excel file.
- Click the Open button.
- Check the worksheet check box.
- Click the Load button.
Note: Some users call Excel worksheets Excel tabs.
After following the steps above, the Excel data will be inside Power BI.
Summary
Learn how to import data into Power BI that is stored in Excel tables.
So, follow the steps above and let us know in the comments if you were able to load data from Excel into Power BI.