Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Salesforce Objects direct connect with PowerBI will reduce Salesforce performance ?

Hi! I have been using PowerBI to set up reports and dashboards connecting via the Salesforce Objects to overcome the limitation (2 000 rows max) of the API with Salesforce reports. In most cases it ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

Calculations that need to cross relationships, especially on large tables, will have a noticeable hit on performance. 

  • Avoid relationships on calculated columns and unique identifier columns.
  • Try setting “Assume Referential Integrity” on relationships – in many cases, this can significantly improve query performance. 
  • Avoid both-directional relationships if possible. 

 

Reference:

Power BI performance best practices

What is the Direction of Relationship in Power BI?

 

Best regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, 

 

Thank you for the response. I think that I need to clarify a bit.

 

My problem is focused on getting the data via the query editor. When accessing Salesforce Objects via the query editor theere is a choice to include so called "Relationship columns". These can then be expanded to show the columns and selecting the ones that are needed. 

 

So there is no calculation involved.

 

There is a huge difference. A Salesforce Object of 150 000 rows will load in 2-3 minutes. If I expand one of the relationship columns that load time will go to 15 minutes or even longer!

 

What can I do to improve that?