Salesforce Objects Join Performance Problem

[Anonymous]

Hello

I am using Desktop to connect to a Salesforce org and extract data using the Salesforce Objects option.

The tables/objects come down fine and I can then filter them and select only the required columns from each without any problems and this is fairly quick.

My problem is that as soon as I try to join any of these tables (using Id columns) together using the merge option the performance becomes unusable with it will just not return even a preview after up to 30 minutes of waiting. This is just joining a table with c. 45k rows with a user table of 8 rows to reduce the number down from 45k rows. I am unable to use Salesforce Reports as the data required is over 2000 rows.

Are there any tips or guidance on how best to use Salesforce Objects and then be able to manipulate the data in Desktop without hitting performance problems? Or why I might be experiencing these problems?

Any help gratefully received.

Rob

[v-jiascu-msft]

Hi Rob,

Is it necessary to join these tables? Maybe you can connect with each other by relationships. This could be the best practices. 

Best Regards,

Dale

[Anonymous]

Hi Dale

Yes unfortunately it is necessary to do the joins as I need to in effect write 2 queries and then join the data together in a 3rd query to get to the results I need.

I have managed to write the queries in Excel using Power Query and it just about runs but is very sproradic as to whether it will complete. When I transfer the same code to PowerBI they will just not run and time out.

Kind regards
Rob