Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful 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
Icon for Community Champion rankCommunity 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.