Error On Data Load and Refresh

I am trying to do a refresh of my dataset on PowerBi Desktop but i keep getting this error below

"OLE DB or ODBC error: [DataSource.Error] ERROR [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents."

Worse still, it first tries to evaluate, then goes on to load some rows but stops after several minutes with the error above.