Is it possible to do Value.NativeQuery in direct query mode in Power BI on online Dataverse table?

[Brutus97]

Hello,

I would like to use direct query in my online Dataverse environment. To keep it the performance in shape, I want to filter the data. So I don't want the whole table in Direct Query.

I 've read that there are possibilities with Value.NativeQuery. But I can't get it working on Direct Query... 

Is this possible? What should be the correct Syntax for this?

Thank you in advance!

I've tried the following:

let
Bron = CommonDataService.Database("???????????.crm4.dynamics.com"),
Filter = Value.NativeQuery(Bron{[Schema="dbo",Item="account"]}[Data], "SELECT top 10", null, [EnableFolding = true])
in
Filter

[sevenhills]

https://www.sharepointed.com/2022/09/filter-a-power-bi-source-before-importing/

https://learn.microsoft.com/en-us/power-query/connectors/dataverse

Check this articles and see ... 

let
   Bron = CommonDataService.Database("{crminstance}.crm.dynamics.com",[CreateNavigationProperties=false]),
   Filter = Value.NativeQuery(Bron, "SELECT top 10 * from dbo.account", null, [EnableFolding = true])
in
   Filter