cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rbitente Frequent Visitor
Frequent Visitor

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 complicated.
Detalhes:
List

 

I don't know how to solve it, my objetic are big (a lot of colluns) but I don't know how to list or to import only the collumns I need (no collumns appear)

 

DO you know how to solve it ?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: 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__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

5 REPLIES 5
Community Support Team
Community Support Team

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

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
rbitente Frequent Visitor
Frequent Visitor

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

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.

 

 

Super User
Super User

Re: 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__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 Frequent Visitor
Frequent Visitor

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

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"

Super User
Super User

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

great to hear Smiley Happy

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