Hello Hemanth Kumar,
Welcome to the Microsoft Q&A and thank you for posting your questions here.
I understand that you are having unexpected status 403 (403 This request is not authorized to perform this operation.
The configuration of your private endpoint and DNS settings is most likely an issue regarding the error code and your explanation.
This is a similar question that has been answered on this platform.
For more details on your DNS settings, the Azure SPN necessary roles, and Azure Storage diagnostic correct configurations to resolve the private endpoint check out this link: https://learn.microsoft.com/en-us/answers/questions/1534786/authorizationfailure-error-403-when-using-private answered by @KarishmaTiwari-MSFT
Also, to review your Terraform configuration for accurate reference the private endpoint and storage account settings: https://learn.microsoft.com/en-us/answers/questions/50768/as-soon-as-i-add-private-endpoint-to-storage-accou answered by @Sumarigo-MSFT
To verify that your local laptop can access the storage account through the private endpoint use this link: https://learn.microsoft.com/en-us/answers/questions/1850074/resolving-403-error-during-blob-upload-with-privat answered by @Abdul
Lastly, even with a private endpoint, the firewall settings need to allow trusted Azure services checkout this answer too: https://learn.microsoft.com/en-us/answers/questions/1166011/getting-a-403-error-when-connecting-to-a-blob-cont answered by @Ramya Harinarthini_MSFT
I hope this is helpful! Do not hesitate to let me know if you have any other questions.
Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.