Sort Table in Process Table(s) in Microsoft SQL Server Management Studio

[LucaFe]

Hi everyone, 

I am currently developing a model. In this model I have two tables linked by the following relations:
TableA *<--->1 TableB
In TableA there is a calculated column based on a column of TableB, and the DAX function RELATED permits to get the column of TableB in TableA. 
When I process the model on azure, I get a memory error if TableA is processed before TableB. 
By default, the Process Table(s) panel in Microsoft SQL Server Management Studio sorts TableA before TableB, while alphabetically and in the Model.bim file TableA is after TableB. How can I modify the default ordering of the panel Process Table(s)? and what is the logic of the default sorting method?

Thank you for reading the quest and I hope that someone is able to help me.
 

[LucaFe]

@Anonymous Thank you for your reply, you were right it was not a problem of processing the table, probably it was bad luck on my tests. The problem solved by itself. 

[Anonymous · Accepted solution]

@LucaFe 

I doubt change the order would make any difference, for OutOfMemoryException you may refer to the workaround provided in the official document.

Exception when you execute a query - SQL Server | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.