locked
Atom Webservice and Parameters RRS feed

  • Question

  • Is there a possilibity to set parameters for an atom feed through powerpivot similar to the parameters when connecting excel to an sql query?

    Monday, December 12, 2011 10:12 AM

Answers

  • Hi Raoul,

    Actually, you have only below two options for filtering the data before you import it. First, you can select specific columns rather than importing every column from the source table. Second, you can apply a filter to a column to select the row values to include in the import. By applying these filtering options, you can eliminate unnecessary overhead in your workbook, reducing both the file size of the workbook and the amount of time necessary to refresh and recalculate the workbook.

    For more information about Atom Data Feeds for PowerPivot, please see: http://social.technet.microsoft.com/wiki/contents/articles/ssrs-2008-r2-atom-data-feeds-for-powerpivot.aspx 

    Thanks,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Challen Fu Monday, December 19, 2011 9:52 AM
    Wednesday, December 14, 2011 6:58 AM