In my report , i am using SharePoint and SQL Datasource and i am using gateway to refresh the data in the SQL . But the refresh is failing with below error message. Not sure why the refresh is failing . Can anyone please let me know where is the problem occurring for this refresh in the online.
|Underlying error code:||-2147467259 Table: Strain.|
|Underlying error message:||The credentials provided cannot be used for the SharePoint source. (Source at https://xxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxx.)|
Our problem (in november 2018) has been solved by an update by Microsoft.
A collegue has told me there seems to be a limit at the number of documents in a sharepoint site that PowerBI can address.
His solution was to split the documents in different document libraries. We didn't tried this solution because our problem was already solved. (our post)
As the error message prompted, please verify that if the credential specified for SharePoint source is correct and still valid. Also, please test whether it can refresh the dataset successfully in desktop version.
I have verified the credentials , it works when i have less number of files in the Sharepoint (like 5 files). But the online refresh fails when the number of files is more than 5 in the SharePoint. And the refresh works fine in the Desktop version regardless of the number of files in the SharePoint.
Did you use On-Premises gateway personal mode and choose OAuth2 as authentication type in your scenario?
I would suggest you create a support ticket for further analysis, as all configurations looks correct and the scheduled refresh should work.