Forum Discussion
Need help reporting on combining opportunity data from two Salesforce instances.
Hello!
We currently have two Salesforce instances and are running separate Opportunity pipeline reports in each. Could someone help guide me, teach me, how to query and chart data from both instances in the same report/Dashboard?
I already have both Salesforce instances and datasets loaded. i.e. - Opportunty1 and Opportunity2 in the right-hand column. How can I turn these two tables into a single dataset that I can use visuals on?
Thank you!
T
Hi Anonymous ,
Have you tried combining the two oportunity tables in Power Query using Append so you'll only get one table? Assuming that the two tables have the same set of columns, this approach should work. Here's a video on how to do this: https://youtu.be/qkmcVHHdQPY
2 Replies
- danextian
Super User
Hi Anonymous ,
Have you tried combining the two oportunity tables in Power Query using Append so you'll only get one table? Assuming that the two tables have the same set of columns, this approach should work. Here's a video on how to do this: https://youtu.be/qkmcVHHdQPY