Forum Discussion
SELECT TOP 1000 [$Table] - Causing poor performance for Incremental Load
I have a table in Power BI I want to incrementally load. Query folding is happening and from the time PBI issues the folded query for a daily partition takes 2 minutes to load from a view on a base t...
If anyone else running into this problem, it is the data source privacy level configuration that causes this TOP 1000 to happen.
Change the data source privacy level to anything else.
Guy in a cube video also explaining this: Reduce the queries being sent with Incremental Refresh in Power BI! - YouTube
Excellent! This saved the day for me. Changed to organizational and refreshes completed in reasonable time.
