Forum Discussion

VuongLM93's avatar
VuongLM93
Helper III
6 years ago

Analyze in Excel - lost Measures?

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 ?

 

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    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.

  • nandic's avatar
    nandic
    Resident Rockstar
    6 years ago

    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.

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    6 years ago

    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.