When I Refresh to get new Loaded data in Excel got error message Power Bi Desktop

[Anonymous]

When I Refresh the Power Bi... It taking more than 30 minutes to get refresh the Data which is Connected to Excel and after few Minutes I was getting the Error message which is below attached ... Please help me asap.. due this is issue My Working as Affected.... I uncheck and Check the Data Load which is in the Options of Power Bi desktop

 

[sayaliredij · Accepted solution]

I think excel data should not be too high to consume your memory.

You can follow the steps below.

1. Check your computer's RAM. if its more than 4GB

2. Close all other applications which are consuming RAM

3. Try to load data one by one (you can right-click on the table and refresh only that table)

4. then you will understand which table has a problem

5. IF you are consuming some long string, columns, please delete them. 

6. In fact from all the tables, delete what is not required. 

7.  Check all the decimals and keep them only till 2 decimal points

after all these checks, try to load again. I am not 100% sure that if it will work but as I don't know how your model looks like, I can assume the above solutions

Regards,

Sayali 

If this post helps, then please consider Accept it as the solution to help others find it more quickly.