PowerPivot Anlyze and Design tabs are missing

[srlabhe]

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 option form PBI Service it opens an excel in web with Power Pivot. While in settings I can edit the format but still the data cant appear in Simple excel sheet format the way it appears when we export the table visual in csv.

Please note I am not exporting in csv because it has more than 30 K recs and I belive PBI has limitations of 30K recs to export in csv.

Also when I try to edit the Power Pivot like excel it shows me a row with repating values like below, also it doesnt help to appear as simple excel format o/p

I checked online I found that there is PowerPivot Analyze and Design option which need to be enabled in Desktop Excel which I already did , but still those options are not appearing here.

Appreciate if any inputs for conveting Pivot Table into simple excel format with easy steps in analyze in excel.

[v-sshirivolu]

Hi @srlabhe ,
I would also take a moment to thank @GilbertQ  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[v-sshirivolu]

Hi @srlabhe ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

[v-sshirivolu]

Hi @srlabhe ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[GilbertQ · Accepted solution]

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.