Forum Discussion

mjjuk's avatar
mjjuk
Helper I
5 years ago

Where clause in Salesforce data

Is it possible to add a where clause to SF data??

 

i have

Let

source= Salesforce.data("https://######.me.salesforce.com",[createnavigationproperties=true]),

knowledge_kav = source{[Name="knowledge_kav"]}[Data]
in 

knowledge_kav

 

it shows an error which is asking for the published status to be stated - but how to I add a where clause into this ???

 

it would also be useful to have a where clause to reduce the initial number of records to be imported

 

thanks in advance 

General Comment
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    mjjuk 

    It asks about publish status of Salesforce report? I guess you should go check the salesforce report status.

     

    When you said where clause I guess your are saying if function or filters in power bi to reduce the data table rows? You can not do that before you load the data into power bi destkop. 

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

    • mjjuk's avatar
      mjjuk
      Helper I
      5 years ago

      It's a shame if you could treat it more like an Sql query then you would be able to join or even limit the number of rows in tables 

       

      the actual error I get is 

      datasource.error: implementation restriction: when querying or searching the knowledge_kav object, you must filter using the following syntax: id = [single id], Id in [list of ids] or published status = [status], in addition publishstatus is only permitted in top-level and condition. 
      details:

      [list]

      how do you circumvent the error above if you can only have. 
      = source{[Name="knowledge_kav"]}[Data]

      thanks