How to automatically refresh Power BI report connected to SAP Business WH, in Power BI Service

Hi Diego_J_Acevedo ,

If the SAP Hana CDS resource is hosted in the cloud and is accessible through the Internet, you may not need a local data gateway to refresh data in the Power BI service.Power BI can connect directly to many cloud services.

If the SAP Hana CDS resource is hosted locally or on a private network, a local data gateway is required to securely connect the Power BI service to the data source. The local data gateway acts as a bridge, providing secure data transfer between the local data source and the Azure cloud service.

For SAP Business Warehouse and SAP HANA, Power BI supports DirectQuery connectivity to set up real-time data refreshes without moving data into Power BI. If the data source is not accessible through the cloud, this method requires careful consideration of gateway settings. For configuration information, you can check out these two documents: DirectQuery in Power BI - Power BI | Microsoft Learn and Configure scheduled refresh - Power BI | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.