Excel memory

[Dennis_Pedersen]

Hi 

We have updated our server and visual studio to SQL Server 2022.

After this we have problems in excel "There is not enough memory to complete this operation"

Excel is connected to our analysis service tabular model.

There are no problems if we make the same report in Power BI dektop.

Our BI server has 48 GB of RAM

Now it seems that excel can only handle very little data, maybe only 5.000 rows and 6 columns.

Can anybody give an idea on how to analyze this ?

[Anonymous · Accepted solution]

Hi, @Dennis_Pedersen 

I think Excel is capable of handling much larger amounts of data, here is some documentation which states that the .xls file format has a limit of 65536 rows per sheet of paper and the .xlsx file format has a limit of 1048576 rows per sheet of paper; you can try upgrading Excel or just work with your data in Power BI Desktop.

What to do if a data set is too large for the Excel grid - Microsoft Support
Excel specifications and limits - Microsoft Support

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Dennis_Pedersen]

No I do not think it is a general problem with excel.

We normally handle much more data.

So it has something to do with a problem when excel is connected to a analysis service cube