Forum Discussion
Table visualization has exceeded resources when adding a single column from related table
Anonymous ,
Although Text Columns require more space and memory to be processed, this kind of thing is not usual. One thing that comes to mind to resolve this is that you need to check if there is any cross join that is happening between the tables when you add this one particular column (from a table with 5C x 10R).
This Cross join when happens could increase the number of records exponentially all at once, there by breaking the memory limit of Power BI
Regards,
Anonymous ,
Although Text Columns require more space and memory to be processed, this kind of thing is not usual. One thing that comes to mind to resolve this is that you need to check if there is any cross join that is happening between the tables when you add this one particular column (from a table with 5C x 10R).
This Cross join when happens could increase the number of records exponentially all at once, there by breaking the memory limit of Power BI
Regards,
I will check on the cross join, although I am not sure how to find that. That feels like the probable cause. And I guess I could have more than one cross join situation with multiple tables. I did do a quick experiment where I merged the desired column to the main data table and then added it to the visualization. That worked fine.