Actualizacion Incremental tabla SQL Server

Hi Anonymous ,

First, it is important to note that upgrade operations in the Power BI service may behave differently compared to Power BI Desktop due to several factors, including upgrade time limits and resource management in the Power BI service.

Since you are using a field for incremental upgrade, here are some recommendations and steps to follow to optimize this process:

Verify the Incremental Update Policy Settings: Make sure your incremental update policy settings are correctly defined in Power BI Desktop before publishing. The settings you mention seem correct, but it is crucial to make sure that the import and incremental update intervals are configured to optimize performance and avoid loading unnecessary data.

Query Optimisation in Power Query: Although you mention that the transformations are minimal, it is essential to ensure that the SQL query used in Power Query is optimised for performance. Consider applying filters directly in the SQL query to limit the data that is initially extracted, rather than loading all records and then filtering them in Power Query.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.