Power Query get Power Pivot data RRS feed

  • Question

  • Hi all,

    I am using the Atomsvc to download the data via Power Pivot and successful loaded in worksheet table.

    Then, I reload the worksheet table to Power Query for data preparation.

    This method is work but I think it is not perfect because  the excel file increase the size as the data stored in the worksheet table

    My question is :

    Can I download the data via Power Pivot but not loaded to worksheet table and directly loaded into Power Query?

    Thank you so much.

    Ank from Hong Kong

    Monday, July 17, 2017 3:16 PM