Connect Microsoft Power BI to SAP Datasphere

[BDC-NR]

Tutorials: https://developers.sap.com/tutorials/data-warehouse-cloud-bi7-connect-powerbi.html

I followed those instructions & it's straight forward. However, a couple of points are missing:

1. This ODBC connection works only with PowerBI Desktop. It would be great to have the steps required if one wants to use this with a published report and scheduled refresh options in PowerBI. It will require the PowerBI Gateway.
2. The ODBC connection works only for Import models, not for live connections. Would be great to have some details how to get a live connection to work.