We had taken data from SAP into SQL Server using Sap Report. Since we are using SQL Server standard edition, I need some guidance on the appropriate gateway to use for scheduling data refreshes in the Power BI service.
-
Gateway requirements: What type of gateway is required for scheduling data refreshes in Power BI when using SQL Server standard edition?
-
Configuration details: Are there any specific settings, code, or configurations needed for the while using SAP into SQL to schedule refresh in Power bi services
? -
Firewall settings: Are there any particular firewall settings or network configurations that need to be adjusted to ensure a smooth data refresh process?
Additionally, if there are any other considerations or steps that I should be aware of for setting up and maintaining the data refresh process, please let me know.
1