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
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 🙂