Forum Discussion

andrewsimmans's avatar
andrewsimmans
Helper I
8 years ago

Analyse in excel using report as source does not pick up measures in the report

I have built some Power BI Desktop reports, that use a dataset as their source. In the reports I have added some measures which are unique to the report and NOT in the dataset to keep the dataset "clean" as each report needs various specific measures. All of this works well.

When I use "Analyse in Excel" by clicking on the three dots next to the REPORT, I expected to see those measures I have added into the report, but I do not, I only see the measures in the base dataset.

Am I doing something wrong - it would be really useful to use the report as the datasource for Excel, including the additional measures I added into the report? 

Need Help

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi andrewsimmans,

     

    This is by design. When you open the downloaded file in Excel, an empty PivotTable and Fields list appears with the tables, fields, and measures from the Power BI dataset. You should create PivotTables, charts, and analyze that dataset just as you would work with a local dataset in Excel.

     

    Reference: Analyze in Excel

     

    Regards,

    Yuliana Gu

    • andrewsimmans's avatar
      andrewsimmans
      Helper I
      8 years ago
      Hi Yuliana

      In Excel you cannot add in extra DAX measures. I have measures that are specific to the report and I do not want to put in the dataset as it is hard to manage as there are many different reports from one dataset. So I expected that if I clicked to analyse a report (not the dataset) in excel I would see these DAX measures.
      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        8 years ago

        Hi andrewsimmans,

         

        It seems that it is not available to view corresponding DAX formulas of exported measures.

         

        Regards,

        Yuliana Gu