Sometimes (randomly as far as i know) the scheduled refresh for the dataset which uses https://XXXX.sharepoint.com/sites/EPM/_api/projectdata fails with the following error:
OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Unable to create platform context. Please ensure that you have Log On Permissions on the server).
If I manually refresh I don't get the error but i don't know why the scheduled refresh is having issues. This is problematic because after 4 failed refreshes the scheduled refresh will stop refreshing. I looked online but can't really find any similar issues.
Any help would be greatly appreciated!
Based on my research, the above error could occur when SharePoint lists have calculated fields. Do you get any errors when removing calculated columns from SharePoint list?
There is a similar thread for your reference.
thanks for your quick reply. I'm not getting any inital errors while connecting. Data set loads fine for about 2 weeks now (refreshes 3 times a day). So my guess is that it shouldn't have anything to do with the calculated columns, otherwise it would have given me the error consistently. The problem with troubleshooting this issue is that i can't seem to replicate the behaviour when it fails. Because that data needs to be up to date very consistently i wanted to understand what is triggering this failure. I think the topic you linked should consistently give an error and not from time to time or did i read it wrong?