Forum Discussion
1.000.000 Row Question
Because we would like to have the newest values. If you go for Import i can schedule a refresh every 30 min for the whole day (48 times). This would be ok if new data is generated every hour or half hour. If the scenario requires that the data is generated every 5 min, than i have a problem. But again my question still is: why does it work? there are more than 1 million rows in database. in power bi service, if i select the whole time i get the result. it id working in direct conection with 2.000.000 rows. why?
Looks like you want to consider Incremental Refresh - It allows you to keep the latest partition (day) in direct query mode and everything else in import mode.
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn