Forum Discussion

FormigoJoao's avatar
FormigoJoao
Frequent Visitor
4 years ago
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 ...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I faced the same issue and despite updating Privacy level to 'Organisational' the top 1000 queries persisted. Having raised this to Microsoft they were unable to replicate the problem. Following investigation we had noted our On-Premise Gateway version was very old (and also no longer supported by MS) and was proposed as possibly being the issue. We have now updated our Gateway software to latest version (3000.146.10) and happy to report we are no longer seeing these top 1000 queries persist. Hope this helps