This may be a sweeping statement but most data in Excel is stored as CrossTab, and not as a basic table (unless an export from another system). 

It seems all LLMs including CoPilot can only function off Tabular structure and not CrossTabs, so unpivoted is a must before you can leverage CoPilot.

My wish would be that Excel supports the CrossTab structure more formally like it does with Excel Table. This will allow CoPilot to seamlessly read crosstab data without the need of the time intensive task of using Power Query to unpivot the data. This is also radically improve import of spreadsheets into Power BI!

Thoughts folks? 

​This may be a sweeping statement but most data in Excel is stored as CrossTab, and not as a basic table (unless an export from another system). It seems all LLMs including CoPilot can only function off Tabular structure and not CrossTabs, so unpivoted is a must before you can leverage CoPilot. My wish would be that Excel supports the CrossTab structure more formally like it does with Excel Table. This will allow CoPilot to seamlessly read crosstab data without the need of the time intensive task of using Power Query to unpivot the data. This is also radically improve import of spreadsheets into Power BI!Thoughts folks?   Read More

​