Data Flows - Error: Data Source Error : DataSource.Error: Web.Contents failed to get contents

[Anonymous]

We have several dataflows in Power BI service and often I get a failed refresh of those dataflows. They fail randomly - when I refresh it manualy or by schedule sometime it is succeed and sometime it is failed with this error:

Error: Data Source Error : DataSource.Error: Web.Contents failed to get contents from 'https://team.xxx.com/sites/xxxxx/_api/web/lists/getbyid('11513b1a-523e-4c6a-8f9c-3f77fcac5aa6')/Rend...' (429): DataSourceKind = SharePoint DataSourcePath = https://team.xxx.com/sites/xxxxx Url = https://team.xxx.com/sites/xxxxx/_api/web/lists/getbyid('11513b1a-523e-4c6a-8f9c-3f77fcac5aa6')/Rend.... RootActivityId = 32f0c3c4-cbcb-41d9-b609-47a873649f62.Param1 = DataSource.Error: Web.Contents failed to get contents from 'https://team.xxx.com/sites/xxxxx/_api/web/lists/getbyid('11513b1a-523e-4c6a-8f9c-3f77fcac5aa6')/Rend...' (429): DataSourceKind = SharePoint DataSourcePath = https://team.xxx.com/sites/xxxxx Url = https://team.xxx.com/sites/xxxxx/_api/web/lists/getbyid('11513b1a-523e-4c6a-8f9c-3f77fcac5aa6')/Rend... Request ID: 227777d1-d36d-d728-0eec-c6848a0ff9bc.

There is a sharepoint folder as a source and that's it.

Do you have any ideas why it happens and how I can fix it?

[Anonymous]

Thank you. I did not find the solution how to fix it, but the acceptable workaround was to schedule 3 refreshes instead of 1.

[ibarrau]

Hi. You might need to read more about the web page or API you are connecting. The lines contain a 429 error. The 429 means "too many requests". You may be exceding the amount of requests to the API in X interval of time.

That's why it might work sometimes and others might fail in that interval.

I hope that helps,