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

Paging file is too small for operation to complete

Im using powerbi desktop 64 bit .

Im trying to import a model from ssas tabular 2014 (v 1103) but keep getting an error regarding memory allocation, saying the paging file is too small for the operation to complete.

 

Capture.JPG

I can see my paging file is almost 16gb in size, and i have almost 8gb of ram free.

The database i am trying to import is tiny, less than 50 megabytes so unsure why memory is an issue.


Appreciate any info or help,Thanks.

3 REPLIES 3
Moderator v-qiuyu-msft
Moderator

Re: Paging file is too small for operation to complete

Hi @wilson_smyth,

 

1. Please choose less dimensions to see if data can be loaded successfully.

2. Please run the latest desktop version 2.49.4831.521.

3. Please enable desktop trace log and repeat steps to reproduce the issue, share the log files with us.

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sandeep_mawri Frequent Visitor
Frequent Visitor

Re: Paging file is too small for operation to complete

Hi Wilson,

 

I am facing too same kind of error.

 

I have below scenarios.

 

I would like to be more precise this time that i have 2 fact tables and the grain is month. So in Fact_Sales Fact table i have transaction for every month and same is the thing with Fact_ExchangeRate Exchange rate for every currency for every month.

 

1st Scenario

So if the user select April 2018 in Ist Tiime period and May 2017 so he must see Transaction Amount for April 2018 and the Comparing Transaction to be calculated should be Transaction Amount for April 2018 Multiplied by Exchange Rate for that currency for May 2017.

 

2nd Scenario

If the User select Year 2018 in 1st Time Period and Year 2016 in 2nd Time Period so he must be able to see Transaction Amount for 2018 and Compared Transaction Amount should be calculated as every month Transaction amount of 2018 multiplied by respective month exchange rate of 2016 and then the sum of it.

 

But when i dont select any specific currency it gives me Paging file is too small for operation to complete .

 

Can you please tell me how to attach the log file.

Impashree Frequent Visitor
Frequent Visitor

Re: Paging file is too small for operation to complete

Hi,

 

Did you get solution for this? I am facing a similar issue.

Please help!

 

Regards,

Impashree

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors