cancel
Showing results for 
Search instead for 
Did you mean: 

Analyze in Excel - Issues with Raw Measures

When trying to Export from PBI via Analyze in Excel, raw measures from the dataset are not "porting" to Excel as measures.

This requires creation of a "Custom" measure which is a duplication of the same data in PBI even though the data column has already been defined as a measure in PBI.

Status: New
Comments
v-lili6-msft
Community Support

hi

I have tested on my side, it works well. all the measures are ported into excel.

5.JPG

 

 

And make sure you select the correct version for your version of Excel.

Please refer this article.

https://exceleratorbi.com.au/power-bi-analyze-excel-what-you-need-to-know/

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

 

 

Regards,

Lin