Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Combine several queries to salesforce

Hello Team, I am trying to load big report from salesforce to Power BI, but it drops due to timeout. So I have created several simular reports in Salesforce (same columns names, but different dates...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  Anonymous ，

 

Try to use Table.Combine funtion in query editor.

See below example:

The related M codes is as below：

let
    Source = Table.Combine({#"Table (2)",Table})
in
    Source

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello v-kelly-msft ,

    I did it already, but it's not what I am looking for in fact.

    Now I have 8 queries to 8 diffrent reports in salesforce. All reports have same columns, but different data.

    I would like to write 1 query to these 8 different reports and receive one combined table.

    How do you think is it possible?

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous ,

       

      Why cant Table.Combine  achieve your requirement?As shown in my example,using it,I combined Table(2) and Table as one query for a combined table,am I missing something?

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Because when I do data refresh Power BI shows that 8 quearies are running instead of one. Maybe it's stupied, but I don't want to merge tables after quesries. I want to merge it while query is executing 🙂