Forum Discussion

jessegorter's avatar
jessegorter
Icon for Helper I rankHelper I
4 years ago
Solved

large datasets - incremental refresh

I was wondering, if I have a p1 capacity, and set up incremental refresh. Can the total dataset size grow beyond the 25 gig max as long as the incremental refresh itself does not consume more than 25...
Need Help
jessegorter's avatar
jessegorter
Icon for Helper I rankHelper I
4 years ago

thanks all! I didn't know the surrogate key could add such a footprint also.

Having said that, the direct query generated by Power BI didn't seem so smart also: fot a distinct count dax, it just sent a "select 2 billion rows from sql table" - query 🙂
is there a way to influence your direct query query based on the dax?