Forum Discussion
Helper IIRefresh failed due to gateway configuration issues
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.
Helper II
Community SupportHi, 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.