Forum Discussion

brcarvalho's avatar
brcarvalho
Frequent Visitor
1 year ago
Solved

Error 431 - Objeto Sales Force

Olá, estou com o erro 431 conforme imagem em anexo, mas minhas bases já estão todas criadas e tratadas dentro do Bi. Nunca tive problemas de atualizações e comecei a ter hoje com esse erro 431. por f...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Cannot reproduce

     

    let
    Source = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=48]),
    Case1 = Source{[Name="Case"]}[Data],
    #"Removed Other Columns" = Table.SelectColumns(Case1,{"Id", "CaseNumber", "AccountId"})
in
    #"Removed Other Columns"

     

    Which version of Power BI Desktop?  

lbendlin's avatar
lbendlin
Super User
1 year ago

Which API version?  How long is your query text?

brcarvalho's avatar
brcarvalho
Frequent Visitor
1 year ago

Olá Ibendlin, obrigada por me responder. Não sei te dizer qual é a API e o tamanho do texto na query, você pode me ajudar a descobrir, por favor?

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Use Query Diagnostics to see the folded query - the URL will also mention the API version.

    • brcarvalho's avatar
      brcarvalho
      Frequent Visitor
      1 year ago

      lbendlin, seriam as informações abaixo?

       

      Fonte = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=48]

       

       

      texto:

       

      shared Negotiation = let
      Fonte = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=48]),
      CLM_Negotiation__c = Fonte{[Name="CLM_Negotiation__c"]}[Data],
      #"Coluna Condicional Adicionada" = Table.AddColumn(CLM_Negotiation__c, "Project type", each if Text.Contains([CLM_RecordTypeName__c], "Renewals") then "Renewals Workflow" else if Text.Contains([CLM_RecordTypeName__c], "Review") then "LAP Workflow" else "blank"),
      #"Linhas Filtradas" = Table.SelectRows(#"Coluna Condicional Adicionada", each true),
      #"Primeiros Caracteres Inseridos" = Table.AddColumn(#"Linhas Filtradas", "Primeiros caracteres", each Text.Start([CLM_GBSAbstractionAnalyst__c], 15), type text),
      #"Colunas Renomeadas" = Table.RenameColumns(#"Primeiros Caracteres Inseridos",{{"Primeiros caracteres", "USER"}}),
      #"Consultas Mescladas" = Table.NestedJoin(#"Colunas Renomeadas", {"CLM_Analyst__c"}, Usuário, {"Id"}, "Usuário", JoinKind.LeftOuter),
      #"Usuário Expandido" = Table.ExpandTableColumn(#"Consultas Mescladas", "Usuário", {"Name"}, {"Usuário.Name"})
      in
      #"Usuário Expandido";

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        So you know the API version is 48. You can change that to a newer version if you want.

         

        Your Power Query code is not actually executed. Your query folds into a custom SOQL query.  Use the Query Diagnostics to see how long that query is. 

         

        - reduce the number of columns you fetch from the CLM_Negotiation__c object

        - try not to add these conditional columns in Power Query

        - definitely don't merge Salesforce Object queries in Power Query.  Let the data model do the work for you but be very careful to join tables based on Case Safe ID (Power BI is not natively case sensitive).