Forum Discussion
crsjunior
4 years agoAdvocate I
Can't Refresh data in Power BI Service
when I try to refresh my data sources in Power BI service I keep geting the error: SharePoint: Request failed: Unable to connect to the remote server In Power BI Desktop it's working and refreshing ...
TomMartens
4 years agoSuper User
Hey crsjunior ,
I assume you configured an on-premises gateway that allows connecting to the Oracle data source after publishing the report to the service.
Did you also connect to the SharePoint data source after publishing the report?
Please provide a screenshot from the dataset connections setting after publishing the report.
Regards,
Tom
crsjunior
4 years agoAdvocate I
Hello TomMartens,
As you can see in the picture Oracle's data source gateway is configured, and the others are all connected with the credentials.
When I publish this same report without doing a Join between Oracle and SharePoint's table in the PowerQuery Desktop, it updates on service, but when I publish with the Join it returns me that error.