Forum Discussion
Visuals exceeded power bi resources
My report has 3 million rows per date, and there is data for two dates, I put a filter for one date and I get visuals exceed power bi resources error I am using Drect Query, does this error occ...
GilbertQ
Super User
Super UserHi 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 ?