@Fienefie As per the confirmation from products team SHIR is the solution as of now. Also, it is currently available for On-premises SQL and the team is working towards enabling this for other Azure sources in upcoming months.
----------
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.