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're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.