Forum Discussion

RUPSY777's avatar
RUPSY777
Icon for Helper II rankHelper II
6 years ago
Solved

Refresh 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 configura...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    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.

     

  • RUPSY777's avatar
    RUPSY777
    6 years ago
    As i am doing it for official purpuse should i go for personal gateway or enterprise one.
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

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.

 

  • RUPSY777's avatar
    RUPSY777
    Icon for Helper II rankHelper II
    6 years ago
    As i am doing it for official purpuse should i go for personal gateway or enterprise one.
    • v-alq-msft's avatar
      v-alq-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      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 supportedPower BI, PowerApps, Azure Logic Apps, Power Automate, Azure Analysis Services, dataflowsPower BI
      RunsAs configured by users who have access to the gatewayAs you for Windows authentication and as configured by you for other authentication types
      Can install only as computer adminYesNo
      Centralized gateway and data source managementYesNo
      Import data and schedule refreshYesYes
      DirectQuery supportYesNo
      LiveConnect support for Analysis ServicesYesNo

       

      Best Regards

      Allan

       

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