Forum Discussion
Visuals exceeded power bi resources
Super UserHi Anonymous
This is because I think a visual has a limitation of how many rows can be returned. When you then combine this with DirectQuery it exceeds the values.
I would suggest importing and then using a measure to achieve the same result
here are more details: Large datasets, data point limits, and data strategies - Power BI | Microsoft Docs
The visual limitation for number of rows limits apply in import mode too ?
- GilbertQ
Hi Anonymous
It should apply, but if you are using a measure it should not return each individual row but rather a single row by date.
so when I use import mode, it takes 4 hours or more just to load into power bi desktop . is this only one time waiting thing ?
Because when i give the same query in oracle it is lightning fast. so import mode loading of 6 million rows into the power bi desktop is only a one time waiting game ? I think once i pubish it to service and schedule refresh, this refresh in import mode should reflect the time the query takes in Oracle ?
well not entirely true right ? also depends on what other fields you drag and drop on visuals, the measure also gets aggregated accordingly