Forum Discussion
DataSource.Error: Query is either selecting too many fields or the filter conditions
let Fonte = Salesforce.Data(), Payroll_element__c = Fonte{0}[Data] in Payroll_element__cthe highlighted in red part means that you drill down to the first row of the column Data - and that's not what you want correct?
if Table.ColumnNames worsk for you, then you can try something like this:let Fonte = Salesforce.Data() ColumnsToBeSelected = Table.FromList(Table.ColumnNames(Fonte)), FilterColumns = Table.SelectRows(ColumnsToBeSelected, each ([Column1] = "Data")), FilteredColumnsAsList = FilterColumns[Column1], Custom1 = Table.SelectColumns(Fonte, FilteredColumnsAsList) in Custom1assuming that Table.ColumnNames returns a list of columns from your Salesforce dataset, you could then filter the relevant columns only when selecting the FilterColumns step
let
Fonte = Salesforce.Data(),
Payroll_element__c = Fonte{0}[Data]
in
Payroll_element__c
the highlighted in red part means that you drill down to the first row of the column Data - and that's not what you want correct?
if Table.ColumnNames worsk for you, then you can try something like this:
let
Fonte = Salesforce.Data()
ColumnsToBeSelected = Table.FromList(Table.ColumnNames(Fonte)),
FilterColumns = Table.SelectRows(ColumnsToBeSelected, each ([Column1] = "Data")),
FilteredColumnsAsList = FilterColumns[Column1],
Custom1 = Table.SelectColumns(Fonte, FilteredColumnsAsList)
in
Custom1
assuming that Table.ColumnNames returns a list of columns from your Salesforce dataset, you could then filter the relevant columns only when selecting the FilterColumns step
Solved !!!
The final was like this :
let
Source = Salesforce.Data(),
Payroll_element__c = Source{[Name="Payroll_element__c"]}[Data],
Select = Table.SelectColumns(Payroll_element__c,{"Name","Date__c","SubsidiaryName__c"}),
#"Linhas Filtradas" = Table.SelectRows(Select, each ([SubsidiaryName__c] = "BRAZIL")),
#"Linhas Filtradas1" = Table.SelectRows(#"Linhas Filtradas", each Date.IsInCurrentMonth([Date__c]))
in
#"Linhas Filtradas1"