You can create an empty actor BP with only a scene component in it, then place it at the location you want the compass to point at. And then Get All Actors of Class > For Each Loop > Cast to your north pole BP. Now you can get the location of that BP and use it as Target.
explanation of casting to a BP placed at the target location and using the “Find Look at Rotation” node is definitely the way to go. After casting to the “target” BP I was able to set a reference to that cast to get the location of the actor. Then with the Find Look at Rotation node, using the location of the arrow as the start and the actor’s location as the target, set the rotation of the arrow to the return value of the Look at Rotation node. You can use a Tick event to update the arrow’s rotation so that it will always point to the target location.