'How to get same data from Salesforce report (Task and Events) - Activity in Tableau

There is a report built in Salesforce from Tasks and Events report type.

Columns in the report pulled from 4 below fields that were autogenerated.

enter image description here

I need to recreate same report in Tableau + visualizations. It would be easy to accomplish if there would be exactly same data in Tableau when I connect to Salesforce.

I don't see Tasks and Events table in the Standard Connection.

enter image description here

I tried to Join them from Table field, however a lot of data and missing and I can't produce same output as in Salesforce directly.

enter image description here

I even tried to use Custom Query to get a single column from the Tasks table (just tested). And I can't even do that by some unknown reason.

enter image description here

Could you please suggest what I can do?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source