Forum Discussion
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 m...
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/
https://exceleratorbi.com.au/table-size-from-power-bi-desktop/
https://www.sqlbi.com/tools/dax-studio/
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/