Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
Solved! Go to Solution.
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
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
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.
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"
great to hear 🙂
@rbitente can you please mark the relevant post as the answer, so that other users can also benefit from it?