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

Analyze in Excel Memory Error

I have a Power BI dataset in the Power BI service and when I try to use Analyze in Excel against the model I receive the error "Memory error: A record (65569 bytes) was encountered that exceeds the maximum page size of the storage object (65528 bytes)." 

 

Twan_0-1603305526138.png

 

I understand that this error is about the size of data in a row being larger than the maximum size allowed in a tabular data model. But, I do not receive this error when I use Power BI desktop to connect to the dataset in the Power BI service which should be using the same API and have the same Analysis Services limitations as using analyze in Excel.  Also, this error is thrown when I try to use fields/measures from any tables in the model.

 

  1. Has anyone run into this error before?
  2. Does anyone know how the size of a row in Power BI is calculated or if it can be viewed in Power BI desktop somehow?
    1. Is the size of a row just the size in that table or is it the combined size of all rows that have a relationship to that table? 
3 REPLIES 3
Super User I
Super User I

have you tried using dax studio to resolve your issue?

https://exceleratorbi.com.au/table-size-from-power-bi-desktop/

https://www.sqlbi.com/tools/dax-studio/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thanks for the link, I tried out DAX Studio and I am able to pull column size but I need to figure out row size which I do not see an option for when I look through the DMVs.  Do you know if there is a DMV that I am missing that would show row size for a specific table?

hmmm I must admit this is not something I have had to do. There is also the performance analyzer in power bi, but not i am not sure if that will help.

Not sure if you have seen this link, maybe there are some tips in there for you?

https://powerbi.tips/2020/07/analyze-in-excel-the-advanced-method/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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