Analyze in Excel - lost Measures?

[VuongLM93]

Dear all,

I  created a report from power bi using my company live dataset

There is 1 measure which I add to this report ( I am not the owner btw) . Then published to Power BI workspace.

When use Analyze in Excel => I cannot find this new measure ( but I can still see in Power BI desktop / service )

What is the problem and how to fix this ?

[v-zhenbw-msft]

Hi @VuongLM93 ,

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/

Or you can create a new pbix file using import mode, publish to Service, then Analyze in Excel.

Observe whether there is a newly created measure.

If there is no measure in the Excel, we suggest you to open a ticket here for help: https://powerbi.microsoft.com/en-us/support/

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nandic]

@VuongLM93 , when using Analyse in Excel, check if there are new automatically created tables. These table have same name as original tables, but these contain only measures from original tables.

Check my demo below. There is Sales table original (bottom yellow) and new automatically created Sales (with sum icon prefix) indicating it contains measures.

[VuongLM93]

Sadly I cannot find this @nandic 

[Greg_Deckler]

@VuongLM93 - I may be incorrect, but I do not believe that measures get imported when doing Analyze in Excel. The purpose of that feature is to ingest the data into Excel to perform analysis.