Why cant i retrive data of excel from sharepoint site's drive

Welcome to the Make community!

According to the error message, you do not have sufficient permissions to edit the Microsoft 365 document with the connection provided.

Try creating a new connection with the account that can access the document.