Forum Discussion
Resolver IAnother Sharepoint Folder Issue- Schedule Refresh **NO/ Desktop Refresh ***YES
HI troyhimes ,
As you may know, the sign on type for both the file and the gateway need to be the same (in this case, Organizational and OAuth2). If those are the same, then I am wondering if the SharePoint permissions (not necessarily your pbix file or your document/list in SharePoint) but the permissions for SharePoint in general and/or how SharePoint is reached have changed. It also could be a firewall/network modification between you and the data source. Can you confirm that this is not the case?
Resolver Icollinq ....maybe this was your point, but still...Odd behavior resulting from differing privacy levels on the data sources.
Excel datasource was incorrect which didn't result in that connection failing on refresh, but rather prevented me from changing the privacy levels of the Sharepoint connection.
3 datasources:
1. on premises SQL db
2. on premises Excel sheets
3. Sharepoint folder
pbix file had correct privacy level settings (Organizational) for SQL and Sharepoint but the Excel sheets were set to private. Everything, as expected, refreshed fine on the desktop.
Scheduled refresh had correct setting for SQL but the Excel sheets were set to Organizational. Both SQL and Excel connections refreshed without issue but the Sharepoint connection failed and I was unable to Sign In when editing the Connection details for Sharepoint.
Once I set (corrected) the Excel privacy level settings in the pbix file to Organizational and published, it allowed me to edit the connection details of the Sharepoint connection and we all lived happily ever after.