Salesforce Report Connectors

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!