Forum Discussion
Helper IIRefresh failed due to gateway configuration issues
Hello,
i tried for the connecting oracle database ,SAP bw with power bi and when i publish in cloud and try to do a scheduled refresh/refresh i face an error "Refresh failed due to gateway configuration issues"-- do i need to install personal gateway or there is some workaround for this ?
Hi, RUPSY777
I'd like to suggest you install an on-premise data gateway. You need to click 'Manage gateway' to set data source definition and then go to dataset settings to map the dataset to the corresponding data source. For further information, please refer Configure scheduled refresh . Do pay attention to the supported data sources and limitations.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- As i am doing it for official purpuse should i go for personal gateway or enterprise one.
4 Replies
v-alq-msftCommunity Support
Hi, RUPSY777
I'd like to suggest you install an on-premise data gateway. You need to click 'Manage gateway' to set data source definition and then go to dataset settings to map the dataset to the corresponding data source. For further information, please refer Configure scheduled refresh . Do pay attention to the supported data sources and limitations.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RUPSY777As i am doing it for official purpuse should i go for personal gateway or enterprise one.- v-alq-msft
Hi, RUPSY777
I'd like to suggest you use the enterprise gateway. Here are differences between two gateways.
TABLE 1 On-premises data gateway Personal gateway
Cloud services supported Power BI, PowerApps, Azure Logic Apps, Power Automate, Azure Analysis Services, dataflows Power BI Runs As configured by users who have access to the gateway As you for Windows authentication and as configured by you for other authentication types Can install only as computer admin Yes No Centralized gateway and data source management Yes No Import data and schedule refresh Yes Yes DirectQuery support Yes No LiveConnect support for Analysis Services Yes No Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
