If it is the Cloud (SaaS) version, OAuth 2.0 is currently required.
If it is the On-Pre version, basic authentication is still available.
As you mentioned, when using Power Automate, there is no need to set up additional OAuth 2.0 authentication because there is a standard connector.
So if you are Cloud (SaaS), you may only consider using Power Automate. It may be possible to use Dataverse integration, but it will become more complicated. . .