Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rbitente
New Member

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
Stachu
Community Champion
Community Champion

 

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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

5 REPLIES 5
v-piga-msft
Resident Rockstar
Resident Rockstar

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.

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
Community Champion
Community Champion

 

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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

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
Community Champion
Community Champion

great to hear 🙂

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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors