Forum Discussion
Super UserPowerPivot Anlyze and Design tabs are missing
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.
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
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
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.