One of the data sources in the Power Bi dataset points to Azure SQL straight (No Data Gateways). Service Principal can take ownership of the data set, but I do not see a way to assign credentials to the SQL data source inside this data set. In this case the credentials of the "managing" service principal would be fine.
