Forum Discussion

armvoss's avatar
armvoss
Icon for Helper I rankHelper I
3 years ago

1.000.000 Row Question

Hello, i have a question regarding the 1 Million Row problem. We have a DirectQuerry Connection to the SQL Database. And an high cardinality of 10 different values per hour on a 24/7 schedule. When ...
General Comment
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

What's your reason for using Direct Query? Would Import Mode be more appropriate? Incremental Refresh even? These options don't have the 1M rows limit.

armvoss's avatar
armvoss
Icon for Helper I rankHelper I
3 years ago

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?