Forum Discussion
Salesforce: JOINED REPORTS
Hello Community!
Has anyone had any success getting Salesforce JOINED REPORTS to work when pulled as a report from Salesforce?
Thanks!
#salesforce
#salesforcejoinedreport
3 Replies
- amitchandak
Super User
AndreeaDillon , Are you looking for this or something else?
https://learn.microsoft.com/en-us/power-query/connectors/salesforcereports
- AndreeaDillonRegular Visitor
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.
- MRileyBDNew Member
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.