Forum Discussion
Power BI Report Server SharePoint Connectivity with Scheduled refresh
Hello,
Are there any advancements about the PBI RS connectivity to a file located in Sharepoint ? This functionality does not allow Scheduled refreshes to run (please see error message bellow) because one can only chose between Anonymous and Windows authnetification whilst we use Oragnizational when refreshing the report from PBI Desktop (which works fine, of course). Thank you for any updates in this, would love to hear that future release will include this functionality to it's best as well. 🙂
SessionID: 301d9969-1d04-4535-977b-53a525fae46c
[0] -1055784932: SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send.. The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784934: The command has been canceled.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Kind regards,
Maria Gorie
1 Reply
The following lists all the supported data sources https://docs.microsoft.com/en-us/power-bi/report-server/data-sources In terms of sharepoint document libraries only sharepoint on-prem is listed and I assume you are using Sharepoint Online. But as you've alluded to, the issue here is that Report Server only supports Windows/Basic/Anonymous authentication. It does not support the other authentication types at this time. The only work around is to move your file to a file share of some sort on your local network.
