Forum Discussion
Dataflow refresh - random failures
I have several Dataflows in a single workspace and from time to time one or more of them will randomly fail to refresh. I cannot see why they are failing. One day they work, the next they fail, the d...
I have the same issue in a workspace integrated with Azure Datalake gen 2. Ramdomicaly fails in different tables of Azure SQL. Sometimes fails on SQL tables, others reading CSVs from Datalake.
The errors are bellow:
| 12/11/2020 09:08:51,SQL XXX Dimensoes,Falhou,dUsuario,11/12/2020 09:13:33,11/12/2020 09:15:05,Falhou,Error: DataSource.Error: AzureDataLakeStorage failed to get contents from 'https://abc.dfs.core.windows.net/powerbi/abc-datalake/SQL%20ABC%20Dimensoes/dUsuario.csv?sp=w&sv=2018-03-28&sr=b&se=2020-12-11T14%bbb%3aaaZ&sig=G%abcabc%3D'. Status code: 500 description: 'Operation could not be completed within the specified time.'. Request ID: 3eafa915-6e31-a779-7773-6882e29c104b Activity ID: 8e7fc620-f0f2-4280-97e5-12d529d48d2d |
| 12/11/2020 08:46:07,SQL XXX Dimensoes,Falhou,dItem,11/12/2020 08:49:19,11/12/2020 08:50:51,Falhou,Error: DataSource.Error: AzureDataLakeStorage failed to get contents from 'https://abc.dfs.core.windows.net/powerbi/abc-datalake/SQL%20abc%20Dimensoes/dItem.csv?sp=w&sv=2018-03-28&sr=b&se=2020-12-11T13%3A49%3A19Z&sig=abc%abc%2FtE%3D'. Status code: 500 description: 'Operation could not be completed within the specified time.'. Request ID: 664f3a8c-c95a-d1a8-91c4-23ea8e31eb89 Activity ID: d1ac7baa-b03e-4afe-8389-84d6f32c5c8e |
| 12/11/2020 08:10:15,SQL xxx Dimensoes,Falhou,dStatusOrcamento,11/12/2020 08:16:08,11/12/2020 08:17:08,Falhou,Error: Internal error Request ID: 14c4293f-c93f-468c-a437-89f0215881cb Activity ID: f6d797e1-c67d-4cd4-b5b1-50fab17a1b13 |