Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

The visual limitation for number of rows limits apply in import mode too ?

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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 ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    well not entirely true right ? also depends on what other fields you drag and drop on visuals, the measure also gets aggregated accordingly