cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Query timeout, out of memory

I am using the Power BI free version. We are working with a transaction table with 120 million rows and 2 dim tables with 5 million rows. The cube processes just fine when we load even the lowest dim levels, but when we try to load the cube with the time dimension as well the cube fails to process and gives out an out of memory error.

 

The cube uses 85% aggregated tables.

 

Kindly advise

2 REPLIES 2
Impactful Individual
Impactful Individual

You should make sure that you're using the 64-bit PowerBI Desktop version and have about 16GB of RAM.

Community Champion
Community Champion

@ankitmane For large volumns of data you can try option of DirectQuery rather than importing in power bi desktop.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors