Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 without any problem.
I have data coming from a Oracle DB and SharePoint. The cause of this seems to be a join I did between the tables in PowerQuey, because when published without this Join it does the automatically update.
Is there some kind of restriction when doing Joins between tables from different source, or any conflict in the DB Gateway?
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
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.