Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Aggregations Multiple Sources

Hi all,

 

I'm trying to use the new aggregations feature with composite models. My data model contains data from multiple sources (we don't have a central data warehouse unfortunately).

 

Is it possible to use aggregations when the data comes from different sources? I have tried but I can't seem to get my queries to hit the aggregation table when filtering on an imported table from a different source.

 

Regards

 

Mike

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Anonymous ,

     

    In power bi desktop, you can import multiple data source and then merge/append the imported tables. In power bi service, you can pin visuals from different report/data source in the same dashboard.

     

    Regards,

    Jimmy Tao

5 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    You can click query editor-> Combine Files to combine different data source tables.

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi, Thanks but I don't think this answers my question. My question was about using the new aggregations feature with data from different sources (different SQL server databases, dataflows etc).

       

      Thanks

       

      Mike

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        Anonymous ,

         

        In power bi desktop, you can import multiple data source and then merge/append the imported tables. In power bi service, you can pin visuals from different report/data source in the same dashboard.

         

        Regards,

        Jimmy Tao

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    It doesn't seem like your question was ever solved. If you have multiple datasources, you need the groupby clause to make aggregations work. Not sure the 'solution' solved this issue. Care to elaborate?