Forum Discussion

lp_sebba's avatar
lp_sebba
Frequent Visitor
5 years ago

Salesforce report: Expression.Error: We cannot convert the value null to type List.

Hi, I am trying to load a Salesforce production report, but get this error immediately on load (already in the preview actually). This occurs for most, but not all reports that I have tried. What ar...
Need Help
GRocha's avatar
GRocha
Regular Visitor
2 years ago

Hello,

 

I also have the same proble when connecting a Salesforce report to PBI. The code from advanced editor is the following:

 

let
Source = Salesforce.Reports("https://nameofmycompany.salesforce.com/", [ApiVersion=48]),
#"Filtered Rows" = Table.SelectRows(Source, each ([Label] = "Product features report"))
in
#"Filtered Rows"

 

When clicking on table 

 

 

it shows up the same error:

 

Also i have tried to changed source but the problem starts exactly when importing:

 Any ideas to solve this?

 

Thanks