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

ReportMaster's avatar
ReportMaster
Post Partisan
2 years ago

Hello rbitente were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

 

 

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

 

 

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.