Forum Discussion

Shg's avatar
Shg
Frequent Visitor
3 years ago

analyze in excel

Hi all,
I'm having a published dashboard. while I'm trying to get access to the measures from "analyze in excel" part, I'm not be able to see all measures values there and they return empty. But for some of the measures I have values. see the below picture.

 

in power bi desktop I created a table from those measures that I couldn't see their values, in that table I could see the values. why it's happening? I need to see their values in "Analyze in excel" as well. What should I do?

 

Thanks in advanced 🙂

Need Help

3 Replies

  • Migasuke's avatar
    Migasuke
    Memorable Member
    3 years ago

    Hi Shg ,

    I have a question - how come you have this "Fx" in your measures? In my case it looks differently.

     

    • Shg's avatar
      Shg
      Frequent Visitor
      3 years ago

      If you open the dashboard and use export button above of the dashboard, measures name would be with fx.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Shg ,

     

    What is your data source? Refer this ,the SSAS property "Default Measure" is not supported by Power BI.

     

    The general limitation is you need explicit measures created in case if you want to use them in the Analyze in Excel. 

    Your dataset in Power BI must have pre-defined measures. Excel PivotTables don't support drag-and-drop aggregation of numeric fields. Read about creating measures.

     

    Please refer to the following document for more information.

    Troubleshoot the connection from Excel to Power BI data - Power BI | Microsoft Learn

    Connect Excel to Power BI datasets - Power BI | Microsoft Learn

     

    Best Regards,

    Neeko Tang

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