Question 1
You have a Microsoft Excel workbook with a spreadsheet named Sales.
You want to use the Sales spreadsheet in a Power BI dashboard report.
How should you prepare the data on Sales spreadsheet?
Answer and explanation
Correct answer: C
Converting data to a flat table in Excel is the essential first step before importing into Power BI. A flat table ensures each column contains the same data type (text, date, number, or currency) and includes a header row without total or summary rows. This structure allows Power BI to properly recognize data types and establish relationships. Simply importing the data, publishing the spreadsheet, or uploading the workbook without proper table formatting will result in data import errors and poor data model performance in Power BI.
