Forum Discussion
Incremental Refresh - TOP 1000
In an enterprise environment the reporting database is decoupled from the production database. You use tools like Informatica to periodically update the reporting database from the production database. That way the Power BI chattiness (which you cannot modify) will not impact your production environment.
Hi FormigoJoao ,
Can you describe the problem you’re having in more detail?
Are you looking to reduce the amount of data on incremental refresh, or are you experiencing incremental refresh timeouts / slowness?
Thanks for your efforts & time in advance.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello
The problem is more on the DB side, we have a SQL DB with a lot of data and we are trying to limit the resources as much as possible but powerbi seems to be the biggest issue with so many queries running and we are trying to figure out a way to supress these queries as much as possible so that we don't push the database's DTUs to the limit since we do have other things that need to be ran on the backend and they can be affected and even fail if the DB is at maximum
In an enterprise environment the reporting database is decoupled from the production database. You use tools like Informatica to periodically update the reporting database from the production database. That way the Power BI chattiness (which you cannot modify) will not impact your production environment.