@KentChen-2307 ,
Thanks for reaching out to Q&A.
Providing Contributor access to the user at the subscription level scope should resolve this issue. A contributor at subscription level should be able to create the resources including App insights.
I hope this helps!
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.