Forum Discussion

srlabhe's avatar
srlabhe
Icon for Super User rankSuper User
11 months ago
Solved

PowerPivot Anlyze and Design tabs are missing

Hi PBI Gurus, I am trying exporting PBI Table visual data in Analyze Excel from PBI Service. But I need the data to be in exactly same format as in PBI Report. But when I do the Analyze in Excel opt...
Need Help
  • GilbertQ's avatar
    GilbertQ
    11 months ago

    Hi srlabhe 

     

    The Powerpivot Analyze and Design feature is an old feature that was previously used. Unfortunately there is no way to do this via a pivot table and you will get it showing as shown as in your image. The only other option I can think of is to write a DAX query which will then query the data and bring it into your semantic model using the Excel get data feature, but that is a lot more complex and is not a drag and drop feature. If I could ask why you're trying to get more than 30,000 records outside of power BR, that might help us better answer your question or provide a solution.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
11 months ago

Hi srlabhe 

 

The Powerpivot Analyze and Design feature is an old feature that was previously used. Unfortunately there is no way to do this via a pivot table and you will get it showing as shown as in your image. The only other option I can think of is to write a DAX query which will then query the data and bring it into your semantic model using the Excel get data feature, but that is a lot more complex and is not a drag and drop feature. If I could ask why you're trying to get more than 30,000 records outside of power BR, that might help us better answer your question or provide a solution.