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.

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi powerbiexpert22 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.