Forum Discussion
Get data from Power BI to Excel - unable to recognize number format
Hi, Anonymous
Try to create a measure (SUM('Table'[Price]))and place the measure into the Pivot Table Value field.
When your Power BI dataset connects to an external OLAP model (which is how Excel connects to Power BI), the PivotTable requires measures to be defined in the external model, since all calculations are performed on the server.
If you take a close look at the Pivot Table Fields list, you will see that there are now 2 types of field groups. The first type (shown as 1 below) are the measures stored in your tables in Power BI. These “measure tables” are indicated by the Sigma symbol. The second type (shown as 2 below) are the actual tables (and columns) from the data model. You select the Values for your Pivot Table from the measures tables (1) and the Rows/Columns/Filters/Slicers from the actual tables (2).
refer:
Can't drag anything to the PivotTable Values area (no measures)Power BI Analyze in Excel – What You Need to Know.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, Anonymous
Try to create a measure (SUM('Table'[Price]))and place the measure into the Pivot Table Value field.
When your Power BI dataset connects to an external OLAP model (which is how Excel connects to Power BI), the PivotTable requires measures to be defined in the external model, since all calculations are performed on the server.
If you take a close look at the Pivot Table Fields list, you will see that there are now 2 types of field groups. The first type (shown as 1 below) are the measures stored in your tables in Power BI. These “measure tables” are indicated by the Sigma symbol. The second type (shown as 2 below) are the actual tables (and columns) from the data model. You select the Values for your Pivot Table from the measures tables (1) and the Rows/Columns/Filters/Slicers from the actual tables (2).
refer:
Can't drag anything to the PivotTable Values area (no measures)
Power BI Analyze in Excel – What You Need to Know.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I had this similar issue and I did creating measures so that I can pull that field into values. The numeric columns are't able to populate in the values field list.
When I create measures, it does pull it into the values field list but it shows numbers same for everything.How can i fix it?