sorry if the description is a bit confusing, using a german excel and perhaps some translations of the functions are not correct.
We connect a excel sheet to a powerbi workspace dataset.
The data appears in excel as pivot
Add / choose some columns is no problem, with a click they appear in the row area
When we try to move some columns in the value area or try to get some results like sum or average this is not possible? Error Message (Translated) You try to move a field in a area of the report which is not possible. Get this message with each column...
What is the mistake? What are the prerequisites and activities to make this possible?