PowerPivot 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.