Forum Discussion

radoslavov91's avatar
radoslavov91
Regular Visitor
1 year ago
Solved

On-Prem connection not working

Hi All,   I need your help with a matter that i have and i cannot find a solution anywhere or don't know where to start from troubleshooting this.   We used to work with an external company that ...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    you made the unfortunate decision to merge your on-prem and your cloud data sources in Power Query. That now requires the cloud data source to be refreshed through the gateway.  However your gateway configuration has that setting "Allow cloud data sources to be refreshed through this gateway"  switched off.

     

    Best advice would be to start over, without merging (instead using the data model joins), so that the cloud data source does not need the gateway.

BhavinVyas3003's avatar
BhavinVyas3003
Icon for Super User rankSuper User
1 year ago

The SAP BW refresh fails because the dataset isn’t correctly mapped to the On-premises Gateway. To fix it, map the dataset to the correct SAP BW data source in the gateway  and ensure server details and credentials match. If needed, update the connection in Power BI Desktop and re-publish the report.