Excel data import in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the first step to import Excel data into Power BI?

Open Power BI Desktop and click on 'Get Data', then select 'Excel' from the list of data sources.

beginner

Why should you check the data types after importing Excel data into Power BI?

Because Power BI might guess wrong data types, and correct types ensure accurate calculations and visuals.

beginner

What does the Navigator window show when importing Excel data in Power BI?

It shows all the sheets and tables available in the Excel file so you can choose which to load.

intermediate

How can you preview and transform Excel data before loading it into Power BI?

By clicking 'Transform Data' in the Navigator window, which opens Power Query Editor for cleaning and shaping data.

intermediate

What is a common issue when importing Excel data with merged cells into Power BI?

Merged cells can cause data misalignment or missing values, so it's best to unmerge cells before import.

Which option do you select first to import Excel data into Power BI?

A Home > New Measure

B File > Save As

C Get Data > Excel

D View > Data

You start by clicking 'Get Data' and then choosing 'Excel' to import Excel files.

What does the Power Query Editor allow you to do with Excel data before loading?

A Transform and clean data

B Create dashboards

C Write DAX formulas

D Publish reports

Power Query Editor is used to clean, filter, and transform data before loading it into Power BI.

If Power BI guesses a wrong data type after import, what should you do?

A Change the data type in Power Query Editor

B Ignore it

C Delete the data

D Restart Power BI

You should correct data types in Power Query Editor to ensure data accuracy.

What does the Navigator window NOT show when importing Excel data?

A Available sheets and tables

B Data relationships

C Preview of data

D Option to select data to load

Navigator shows sheets and tables but does not show data relationships.

Why is it best to avoid merged cells in Excel before importing to Power BI?

A They increase file size

B They speed up import

C They improve data quality

D They cause data misalignment

Merged cells can cause data to misalign or be missing in Power BI.

Explain the process of importing Excel data into Power BI from start to finish.

Think about the steps you take from opening Power BI to seeing your Excel data ready for reports.

What are common data issues to watch for when importing Excel files into Power BI and how do you fix them?

Consider what can go wrong with Excel data and how Power BI tools help fix it.