Use Service Principal to Refresh data source in SharePoint Online?

Hi,RolandPlanet .Thank you for your reply.

Thank you for your reply.
Based on your description and the screenshots provided
Your first attempt is correct and should be used:

Application (client) ID as the service principal ID

In this case, you are getting the following error:

“Failed to update data source credentials: The credentials provided for the Web source are invalid” error
I assume that your web data source redirection URL is not working and suggest you to regenerate it.

According to your error message, you need to check if the following configuration information is correct

Tenant ID:Green Area
Service principal ID:Red area
Service principal key:Pink area

Please double-check that your API permissions and other information configurations are set correctly (correct API permissions need to be configured)

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.