Forum Discussion
Error 431 - Objeto Sales Force
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?
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).
não sei se entendi completamente sua sugestão.
1) como consigo remover colunas do objeto de negotiation? porque o botão 'remover colunas' não está habilitado
Para diagnosticar seria nessa opção?
1. do it one step higher, right after navigation
2. correct.
realmente não estou conseguindo escolher as colunas após a navegação. eu consigo adicionar pelo editor avançado? também tentei, mas como não consigo saber as colunas, não consigo ajustar no editor quais são
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?