Bird
0
0

What type of Excel file formats can Power BI import directly?

easy📝 Conceptual Q1 of 15
Power BI - Getting Data
What type of Excel file formats can Power BI import directly?
A.xlsx and .xlsm
B.txt and .csv
C.docx and .pptx
D.pdf and .html
Step-by-Step Solution
Solution:

  1. Step 1: Identify supported Excel formats

    Power BI supports importing Excel files with extensions .xlsx and .xlsm which are standard Excel workbook formats.

  2. Step 2: Exclude unsupported formats

    Formats like .txt, .csv, .docx, .pptx, .pdf, and .html are not Excel formats and require different import methods.

  3. Final Answer:

    .xlsx and .xlsm -> Option A

  4. Quick Check:

    Excel file formats = .xlsx and .xlsm [OK]
Quick Trick: Power BI imports .xlsx and .xlsm Excel files directly [OK]
Common Mistakes:
  • Confusing Excel files with text or document formats
  • Assuming .csv is an Excel format
  • Trying to import unsupported file types directly

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Card and multi-row card - Quiz 1easy Basic Visualizations - KPI visual - Quiz 12easy Data Cleaning with Power Query - Pivoting columns - Quiz 3easy Data Cleaning with Power Query - Removing duplicates - Quiz 8hard Data Cleaning with Power Query - Pivoting columns - Quiz 13medium Formatting and Design - Title, labels, and legends - Quiz 15hard Formatting and Design - Why design improves report clarity - Quiz 14medium Getting Data - CSV and text file import - Quiz 9hard Getting Data - OData and REST API connections - Quiz 12easy Power BI Basics and Architecture - Interface overview (Report, Data, Model views) - Quiz 5medium