Results 1 to 2 of 2

Thread: PowerPivot drill down capabilities

  1. #1
    Acolyte albertan's Avatar
    Join Date
    Nov 2017
    Location
    Canada
    Posts
    24
    Articles
    0
    Excel Version
    2013

    PowerPivot drill down capabilities



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    103
    Articles
    0
    Excel Version
    365
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •