Publishing report that references a SharePoint list data source using a service principal

We have a report that references a SharePoint List data source. We have created an Azure Pipeline to publish this report to Power BI service using the PowerShell modules and API calls. The API calls are done using a service principal and this service principal has been granted Developer API access.

The problem seems to be that the SharePoint data source seems to be tied to the original report author, and so when the report is published, it won't allow you to refresh the data.

A similar approach does seem to handle data sources (eg. SQL) that use a gateway, as in that case we can update the users for the data source to include the service principal, but SharePoint data sources don't have this option.

Is there a way for the service principal to create or update the SharePoint data source? Do I need to do anything in SharePoint to allow a service principal account to access the data?

David