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?
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?