Forum Discussion
Where clause in Salesforce data
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.
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