Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Salesforce Report Connectors

Hello, can anyone explain or route me to how the 'Salesforce Reports' & 'Salesforce Objects' connectors work behind the scenes when the report is published to service and being interacted with. I cou...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Basically, the connector calls the Salesforce API. But the connector isn't the cause in your scenario. Since it isn't a Direct Query connection, the reports consume the data stored in the Service. For instance, the report loads the data in the Service rather than retrieving from Salesforce when you select options in the Sclier. 

1. Do you have any complicated measures?

2. Does the report run fastly in the Desktop?

3. How about now? Maybe a temporary issue.

 

 

Best Regards,
Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    1. Do you have any complicated measures? No

    2. Does the report run fastly in the Desktop? No

    3. How about now? Maybe a temporary issue. Still happens

     

    Thanks for the response Dale, is it just storing the data in the service or data with relations ? Are the relations built on the fly ?

     

    The issue I had is.. first of all I am not using any complex measures, there are all doing simple counts.

    I have 3 visuals on the report:  

    2 table grids, 1 of them using 2 tables and other from a single table and both run fine. 

    There is a matrix visual which is using objects from 4 different tables and the join conditions are on an alphanumeric columns, which is causing the issues, it also throws an out of memory error in the service but shows data on the desktop copy.

     

    I have my colleague who worked on a similar report type in his previous org and never had any issues. We are kind of thinking it may be due to the salesforce configuration itself, in the meantime I am using the salesforce report connector and had my salesforce team build a report for me with desired fields and it works great. I'll post here if we could debug this issue but please throw any ideas/suggestions/information you guys have.

     

    Thank you!

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

      What's the size of your dataset?

      Do you mean "the join conditions" is the relationship? 

      Can you share some snapshots? At least how the dataset looks like and the Matrix you created.

       

       

      Best Regards,
      Dale