When source tables are heavily used and ODX Server performs a load, the process is very slow or may even fail.
Using Business Unit, we have the option to 'Allow Dirty Reads' to allow TX to read tables without locking them. This option lacks in ODX Server.
Currently we have to add all tables as a Managed Query, adding the WITH NOLOCK statement. Ticket #18989.