Salesforce: JOINED REPORTS

[AndreeaDillon]

Hello Community!

Has anyone had any success getting Salesforce JOINED REPORTS to work when pulled as a report from Salesforce?

Thanks!

#salesforce

#salesforcejoinedreport

[MRileyBD]

Bumping this thread back up.  I am having the same issue when trying to use the Salesforce Reports connector from Power Bi.  I get the following error:

Expression.Error: We cannot convert the value null to type List.
Details:
Value=
Type=[Type]

The Salesforce Reports connector works great when connecting to a regular report.  This error only occurs when trying to connect to a salesforce.com report that is a 'Joined 'Report.'  Any help would be appreciated as this report type in salesforce is very helpful when working with large tables and data sets.

[amitchandak]

@AndreeaDillon , Are you looking for this or something else?

https://learn.microsoft.com/en-us/power-query/connectors/salesforcereports

[AndreeaDillon]

Thanks for the link, but it goes over the general reporting tool for Salesforce, which I already have connected.  Where i'm having an issue is with a special type of report that is available in Salesforce called a "Joined Report" where you basically join two different reports and with a common field.  I get an error message when I try to connect to a report of that type.