Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
juangomez
Helper I
Helper I

Analyze in Excel Downloads as text

Hi Everyone

 

I am downloading the Analyze in Excel file but every number field is read as text in the Power Pivot table.

So I am not able to sum, average or do any calculations.

 

Where did I go wrong?

 

I am not able to inser the field GS (numeric) field in values. I know it downloads with the correct decimal format as I am downloading it with "." but a partner with different regional configuration downloads it as ",". But we both have the same issue working with the data.

 

Analyze in Excel Error.JPG

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @juangomez ,

 

As the online documentExcel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures. Read about creating measures.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

Thank you for the information 

 

I created the measure in my report but it is not shown in my connected Pivot Excel file. What I am doing wrong?

Mikitem_0-1636552816244.png

 

 

Mikitem_0-1636552988543.png

 

 

 

v-frfei-msft
Community Support
Community Support

Hi @juangomez ,

 

As the online documentExcel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures. Read about creating measures.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
JirkaZ
Solution Specialist
Solution Specialist

@juangomez You will have to define those numbers as measures in your model in Power BI

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors