'Import data from Salesforce Report using ADF not working

I am working on importing data from Salesforce Report using ADF. I am using copy activity and have created salesforce linked service.

I followed the Microsoft documentation https://docs.microsoft.com/en-us/azure/data-factory/connector-salesforce to setup the ADF. I am getting empty rows.

Used this tip: Get Salesforce reports by specifying a query as {call "<report name>"}. An example is "query": "{call "TestReport"}".

I can see header information but all rows are empty. What I am missing here?

azure salesforce

Sources

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

Solution	Source