The fundamental limit is given by the 2nd law of thermodynamics - you can never reach higher temperatures than the surface of the sun, or around 5800 K. We have the atmosphere that absorbs and scatters some of the light, so on the surface of the earth it is a bit lower, but not by a huge amount.
This means that there is a fundamental limit to how small and intense you can make the focal spot in a solar concentrator. The limit is around ~45 MW/m² or 45000 "suns" (which is plenty high, but far from infinite).
Concentrators used for eletricity generation use much lower concentration than this, on the order of 25 suns to 1000 suns depending on the type. There are also solar furnaces designed for reaching much higher concentration by using a different type of optics. The most impressive one is the huge Odeillo solar furnace [1]. I would guess that they could melt tungsten, but I have not actually run the numbers.
I did a talk last week about a concept we are developing for reaching furnace-level concentration ratios with conventional heliostats [2].
[1] https://en.wikipedia.org/wiki/Odeillo_solar_furnace
[2] https://folk.ntnu.no/haakonjj/talks/2024-08-19-nonimaging-fr...