Forum Discussion
Solved
Incremental Refresh - TOP 1000
Hello, I am trying to set up Incremental Refresh and I noticed that it is doing a lot of TOP 1000, basically for each partition. A TOP1000 isn't that much but it adds up and since we are dealing ...
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.
Probably not. I assume you have a Pro license. Consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/ and then work with the SI to get ahold of the product team that manages the partition handling. In the end it all comes down to meta data.