Forum Discussion

pixelicous's avatar
pixelicous
Frequent Visitor
9 years ago

Azure content pack for PowerBI - Analyzing data in excel

Hi all,   I have the same issue as the following post: https://community.powerbi.com/t5/Service/Analyze-in-Excel-of-Azure-Entreprise-dataset-No-measures/td-p/66535   I tried replying on that pos...
Need Help
pixelicous's avatar
pixelicous
Frequent Visitor
9 years ago

Thanks for replying eno1978..  It seemed from the post that it is possible to create an element that will turn the COST field to be able to be maniuplated in a way that it would be useable, thus i asked..

 

The guys on that post explained the situation and what needs to be done but it didn't seem like it isn't possible with the current option, like there is a way to create a dataset using that service connection to download a schema or  amodel and based on that tweak it a bit so analyze in excel would be helpful..

 

How come such an important content pack is released without the ability to do anything in powerpivot with it..

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi pixelicous,

 

You can use analysis in excel function to export data model to excel, but I don't think it will be possible to create a content pack which support drag and drop column to values field.

 

Regards,

Xiaoxin Sheng

  • pixelicous's avatar
    pixelicous
    Frequent Visitor
    9 years ago

    I understood from what you replied to the original poster that it can be somehow achieved..

     

    So it cant?

     

    There is no way to use the azure for enterprise content pack in order to analyze data correctly in excel??

    The fact that the cost cannot be used as a value completely renders the analyze in excel to be obselete...

  • pixelicous's avatar
    pixelicous
    Frequent Visitor
    9 years ago

    Following what i wrote above.. basically i am not looking to create any content pack, i just want to use that data model correctly in excel, thats my end game? is that somehow possible?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi pixelicous,

       

      Not very sure for your "i just want to use that data model correctly in excel".Can you share some detail content to let us more clearly for your requirement?

       

      Powerpivot only support measures in value filed. If you want to use column in it, you need to create a measure with max, sum, average or other math function to summary column value.

       

      Regards,

      Xiaxin Sheng

      • pixelicous's avatar
        pixelicous
        Frequent Visitor
        9 years ago

        Well..

        Very simple, the Azuer content pack for enterprise currnetly only works in PowerBI web version.

        There are many limitations due to this so i thought i'll start analyzing the data in excel.

        I use "analyze in excel" option and open the downloaded connection file with excel.


        I can see the COST field is a measure itself (in powerbi web), but in excel i cannot use it under the value fields.

         

        Is there a way to make that work?? Analyze in excel is rendered obselete without it, because having the cost as a row is simply not helping in anything.

        Again, i do not want to use the cost field as a column but in the VALUE field..

         

        Is there ANY way to do that currently? i am rather newbie to this so any help would be appreciated.. :)