As Tim suggests, using the PowerBI Gateway to connect to the On-Premises SQL is the way to do it. It's fairly easy to set up, can't really break anything. Give it a go.
The Gateway provides a conduit from PowerBI to On-Premises SQL. You still design your PBI using the PBI Desktop then publish them to the PBI cloud and connect to the D365/CRM DB via the gateway.
If you've found this thread useful, dive deeper into User Group community content by role