Forum Discussion

crsjunior's avatar
crsjunior
Icon for Advocate I rankAdvocate I
5 years ago

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 ...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
5 years ago

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's avatar
    crsjunior
    Icon for Advocate I rankAdvocate I
    5 years ago

    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.