Forum Discussion

rbitente's avatar
rbitente
New Member
7 years ago
Solved

DataSource.Error: Query is either selecting too many fields or the filter conditions

Hello Guys !   I am facing the folling problem to retrieve the objetic list from Salesforce   DataSource.Error: Query is either selecting too many fields or the filter conditions are too complica...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

     

    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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi rbitente ,

For your issue, please have a reference of this similar thread which had been solved.

If you still need help, feel free to ask.

Best  Regards,

Cherry

 

rbitente's avatar
rbitente
New Member
7 years ago

I tried to do what this post tells, but didn't work.

 

My advenced editor was like this:

 

let
Fonte = Salesforce.Data(),
Payroll_element__c = Fonte{[Name="Payroll_element__c"]}[Data]
in
Payroll_element__c

 

And I modified to this

 

let
Fonte = Salesforce.Data(),
Payroll_element__c = Fonte{0}[Data]
in
Payroll_element__c

 

But is not bringing what I need.

 

 

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

     

    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

    • rbitente's avatar
      rbitente
      New Member
      7 years ago

      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"

      • Stachu's avatar
        Stachu
        Community Champion
        7 years ago

        great to hear :)

        rbitente can you please mark the relevant post as the answer, so that other users can also benefit from it?