according to https://docs.microsoft.com/en-us/azure/data-factory/connector-salesforce#query-tips, you should be able to reference a Salesforce report:
You can retrieve data from Salesforce reports by specifying a query as {call "<report name>"}. An example is "query": "{call \"TestReport\"}"
However I´m not able to hit the correct terminalogy, I keep getting error below when I preview the data:
ERROR [HY000] [Microsoft][Salesforce] (120) SOQL_FIRST mode prepare failure: SOQL error: [Microsoft][SQLEngine] (31480) syntax error near '"<<< ??? >>>query": "{call \"SQLOpportunities\"}" '. SQL error: [Microsoft][SQLEngine] (31480) syntax error near '"query"<<< ??? >>>: "{call \"SQLOpportunities\"}" '. . Activity ID: a8eabad6-8a3a-4920-8107-bf962621e7a9
I´m going nuts, any help would be hugely appreciated
BR
Mogens