[h=1]How to override the 1000 Row Drilldown limit in either PowerPivot or PowerBI.com Analyse in Excel.
In a normal Excel pivot table when you double click on a cell you can see the build out of that number i.e. the underlying numbers/transactions making up the summary figure, which sometimes might be many thousand rows of data. However in PowerPivot or PowerBI.com Analyse in Excel the number of rows is limited to 1000 rows. Does anyone know how to override that 1000 number[/h]
It might be easier and more clear if I show you it rather than try to explain it
http://www.youtube.com/watch?v=_Wqm9KNjy54
Any Ideas?
Thanks
Ed
In a normal Excel pivot table when you double click on a cell you can see the build out of that number i.e. the underlying numbers/transactions making up the summary figure, which sometimes might be many thousand rows of data. However in PowerPivot or PowerBI.com Analyse in Excel the number of rows is limited to 1000 rows. Does anyone know how to override that 1000 number[/h]
It might be easier and more clear if I show you it rather than try to explain it
http://www.youtube.com/watch?v=_Wqm9KNjy54
Any Ideas?
Thanks
Ed