Msg 15274, Level 16, State 1, Line 6

Access to the remote server is denied because the current security context is not trusted.

I am getting the same error for a linked...

Try this.  I created a smaller version of your table and cut down on the data.

CREATE TABLE dbo.CIMBalances (
[Entity] nvarchar (10) not null,
[Account] nvarchar (10)...