Forum Discussion

Brutus97's avatar
Brutus97
Frequent Visitor
2 years ago

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

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