add pivot table based on two queries without loading the data into the data model RRS feed

  • Question

  • Hi All

    I can insert a Pivot Table and use a Query as an "External Data Source" and so rely on a query that is only a connection (not pooling the data into the data model).

    My question is

    If I want to build a Power Pivot (so - a pivot based on two such "connection only" queries) - how can I do that?

    The interface only allows to select one query.

    I can pool the data from each query into the Data Model and then create a Power Pivot using the Data model, but I am trying to avoid doing that.

    Thanks for your help!


    Thursday, March 5, 2020 1:03 AM