Forum Discussion
Dataflow refresh fails on Azure SQL Data Warehouse
When i design a dataflow with multiple tables based on Azure SQL Data Warehouse, the data gets loaded into my preview windows (i have added multiple tables). When i then save the data flow and try to refresh i get the message that the refresh failed (the yellow warning sign).
I've tried to reenter my credentials in the settings page of the dataflow, but the problem persists. I'm using basis authentication (a SQL Server username and password).
What could be the problem?
8 Replies
- Hi mvogt_ilionx, Can you please share the details of the error you get? Go to the refresh history and clink the download link on the right side to get the csv file with all the error details. thanks, Maxim
Hi Maxim,
The (anonimized) contents of the csv are below:
Run time Dataflow name Dataflow refresh status Entity name Start time End time Entity refresh status Error 01/10/2019 07:59 xxxx Failed xxxx 10/01/2019 07:59 10/01/2019 07:59 Failed Error: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: 62241a40-9620-4f8f-9caa-52262131b82e 01/10/2019 07:59 xxxx Failed xxxx 10/01/2019 07:59 10/01/2019 07:59 Failed Error: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: a8e6ca2e-2dfa-494b-a293-2d073b4e34da 01/10/2019 07:59 xxxx Failed xxxx 10/01/2019 07:59 10/01/2019 07:59 Failed Error: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: 17ab3af6-c00e-42c6-a451-9b1bc177bc1a 01/10/2019 07:59 xxxx Failed xxxx 10/01/2019 07:59 10/01/2019 07:59 Failed Error: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: e65c7f58-cf08-48bd-8a82-c4ecf4a4ae27 01/10/2019 07:59 xxxx Failed xxxx 10/01/2019 07:59 10/01/2019 07:59 Failed Error: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: 8881b076-ac4d-413b-8bc8-5844e0b61d6d 01/10/2019 07:59 xxxx Failed xxxx 10/01/2019 07:59 10/01/2019 07:59 Failed Error: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: 7fcd4af2-91d4-4162-99dd-db96bd8c699c Kind regards,
Matthijs
- While we investigate this issue, can you please comment whether it persists?
Does retiryng the refresh help?
