Excel Pivot (Source PowerBI Workspace) - Move Columns in Value are not possible



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?

0 Replies