Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 ?
Solved! Go to Solution.
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.
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.
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.