This is now possible thru the UI of PowerBI. The data gateway does need to be able to reach public PowerBI and the internal sql server. If you want to automate this, the API used is still not documented.

I've created a method of encoding the credentials and published my results.

https://github.com/Audiodude-nl/PowerBIEncryptSP/blob/main/README.md