Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago
Solved

Excel Formats as source

Which Excel formats (table or pivot) is easier for Power BI to read when using Excel as the source?
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    Excel Tables are easier for Power BI to read—structured, refreshable, and stable. Pivot Tables are harder—layout changes can break connections. Always prefer tables.

Shahid12523's avatar
Shahid12523
Community Champion
1 year ago

Excel Tables are easier for Power BI to read—structured, refreshable, and stable. Pivot Tables are harder—layout changes can break connections. Always prefer tables.