Forum Discussion
Solved
Excel Formats as source
Which Excel formats (table or pivot) is easier for Power BI to read when using Excel as the source?
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.
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.