RE: How Embeded POWER BI to Dynamics 365 CFO Overview (Power BI embedded is not enabled)
No you would have to pay for the SQL Server in step two of the link I sent you, that's the expensive part.
You can only install the PowerBI Embedded Service on Azure until July 2018. Then you can only run it until Dec 2018. After that it goes away as far as I understand. I have heard that MS will come out with a new way to embed to D365 soon and hopefully less expensive.
This is all just what I have heard talking to different people, this is not official from MS.