Where clause in Salesforce data

[mjjuk]

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 

[Anonymous]

@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]

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