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)."
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.
Has anyone run into this error before?
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?
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?
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?