PowerPivot drill down capabilities

albertan

Member
Joined
Nov 9, 2017
Messages
30
Reaction score
0
Points
6
Location
Canada
Excel Version(s)
2013
Hello, if I understand this correctly, Power Pivot is only good if one works with large data.
So, I cannot bring data into excel (after I do connection) other than using Power Pivot?
If I drill down, will it only bring 1000 lines?

If that is the case, what's PowerPivot is good for? Doing just Pivot tables for large data?
 
Hi,

Power Pivot is not only good for analyzing large dataset, its DAX language is very powerful for making complex analysis easy within a pivot table.

You can also use DAX as a query language, and querying your entire data model as a table in a worksheet, and you will get the entire result of your query without the limit of 1000 rows


To learn more, visit my personal blog http://numidiabi.wordpress.com
 
Back
Top