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 are my options?

Best regards, Alex

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    lp_sebba , right click on the table and share the script from the advance editor. check some step with list, that is having problem

    • lp_sebba's avatar
      lp_sebba
      Frequent Visitor
      5 years ago

      Thank you amitchandak for the quick reply.

       

      The script is very short...

      let
      Source = Salesforce.Reports("https://login.salesforce.com/", [ApiVersion=48]),
      #"00O1G000002UMZVUA4" = Source{[Name="00O1G000002UMZVUA4"]}[Data]
      in
      #"00O1G000002UMZVUA4"

       

       

      • v-kkf-msft's avatar
        v-kkf-msft
        Community Support
        5 years ago

        Hi lp_sebba ,

         

        Please refer to the documentation https://docs.microsoft.com/en-us/power-query/connectors/salesforcereports   and reconnect.

         

        If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

        Best Regards,
        Winniz

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • 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