In power query, you're able to define a native query and run it against your data source.

Query folding. Chris webb wrote an excellent blog post about using value.nativequery() function. What is query folding in power bi(power query)why query should be foldedhow to identify query folding in power query#powerbi #powerbidesktop #powerbitutorial. Query folding is the ability for a power query query to generate a single query statement that retrieves and transforms source data.

To stop query folding taking place for this filter transformation you can add an extra step to the m code of your query using the table.stopfolding function like so: Since you are using odbc connector, whether query folding is working or not can be checked in 2 places. The goal of query folding is to offload or push as much of the evaluation of a query to a data source that can compute the transformations of your query.

Query folding is very effective with large databases when you are looking to improve refresh time or just to load and transform large amount of data quickly. Finally, query folding is also of key importance for incremental refresh — it’s so important that power bi will warn you once it determines that query folding can’t be achieved. The reason why you can consult the documentation:

Let’s illustrate the date filter. There are some improvements recently to query folding when writing native sql queries. Query folding is a way to allow power bi (its engine) to push some of the transformations done in power query back to the database, and let it do what it’s good at.

Now, it’s time to learn how can we check if the specific query folds or not. With that, we’ll be able to see the command that. Hi @thai_nguyen96 , you can configure incremental updating for this dataset, it is simply not recommended.

This query took 32 seconds to load 2.8 million records in my power bi report. Using “removing rows with errors” prevents query folding. For more information, see power query.