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.
I've done some testing, and looks like the dataset must be published to PPU/Premium workspace.
When published to Pro workspace or to "My Workspace" the TOP 1000 queries would show up, even with Organizational privacy level.
No idea why it's like that, but this is really problematic for large DBs (Azure SQL DB). I hope someone from PBI team could help here.