Refresh failed: OData Version: 3 and 4, Error500

[BelleNAP]

Ever since I started to use Power BI, I have this refresh issue as below:

• Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (The request uses too many resources.) OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (The request uses too many resources.)

  Next refresh for AnnualLeaveCount_TimeOffBal2 is scheduled for 01/05/2017 05:32:00. 

         Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData

It is confusing that the refresh sometimes will succeed while at most times fail. Even if I click on" Refresh Now" at times it will take me 2 to 3 tries to succeed.

May I know why this happens and how can I solve it? Thanks

[BelleNAP]

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.

Data source typeSharePoint

Processing errorMicrosoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (The request uses too many resources.)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (The request uses too many resources.)

Cluster URIWABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

Activity ID7d514c99-c9e3-4856-b31f-c475c58c59ed

Request ID9298e3f0-3344-47f1-9607-16a94e12604c

Time2017-01-03 11:07:10Z

[v-qiuyu-msft]

Hi @BelleNAP,

What's the data source did you use in the dataset? Please check if the dataset has one OAuth data source with one or more other data sources. If that is a case, it's a known issue, see: https://powerbi.microsoft.com/en-us/support/

Best Regards,
Qiuyun Yu

[BelleNAP]

Data source is sharepoint list + an Excel file posted on sharepoint.