Reply
Highlighted
Frequent Visitor
Posts: 8
Registered: ‎10-11-2018
Accepted Solution

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?

 

 


Accepted Solutions
Frequent Visitor
Posts: 8
Registered: ‎10-11-2018

Re: Dataflow refresh fails on Azure SQL Data Warehouse

I've retried the refresh and as of now it's working. Thanks!

View solution in original post


All Replies
Power BI Team
Posts: 12
Registered: ‎06-25-2017

Re: Dataflow refresh fails on Azure SQL Data Warehouse

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
Frequent Visitor
Posts: 8
Registered: ‎10-11-2018

Re: Dataflow refresh fails on Azure SQL Data Warehouse

Hi Maxim,

 

The (anonimized) contents of the csv are below:

 

Run timeDataflow nameDataflow refresh statusEntity nameStart timeEnd timeEntity refresh statusError
01/10/2019 07:59xxxxFailedxxxx10/01/2019 07:5910/01/2019 07:59FailedError: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: 62241a40-9620-4f8f-9caa-52262131b82e
01/10/2019 07:59xxxxFailedxxxx10/01/2019 07:5910/01/2019 07:59FailedError: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: a8e6ca2e-2dfa-494b-a293-2d073b4e34da
01/10/2019 07:59xxxxFailedxxxx10/01/2019 07:5910/01/2019 07:59FailedError: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: 17ab3af6-c00e-42c6-a451-9b1bc177bc1a
01/10/2019 07:59xxxxFailedxxxx10/01/2019 07:5910/01/2019 07:59FailedError: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: e65c7f58-cf08-48bd-8a82-c4ecf4a4ae27
01/10/2019 07:59xxxxFailedxxxx10/01/2019 07:5910/01/2019 07:59FailedError: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: 8881b076-ac4d-413b-8bc8-5844e0b61d6d
01/10/2019 07:59xxxxFailedxxxx10/01/2019 07:5910/01/2019 07:59FailedError: Internal error Request ID: b2aa87a5-3274-82eb-580a-381a476639dc Activity ID: 7fcd4af2-91d4-4162-99dd-db96bd8c699c

 

Kind regards,

 

Matthijs

 

Power BI Team
Posts: 12
Registered: ‎06-25-2017

Re: Dataflow refresh fails on Azure SQL Data Warehouse

While we investigate this issue, can you please comment whether it persists?
Does retiryng the refresh help?
Frequent Visitor
Posts: 8
Registered: ‎10-11-2018

Re: Dataflow refresh fails on Azure SQL Data Warehouse

Unfortunately retrying gives me the same error. I just now tried again and no succes.

 

Thanks!

Frequent Visitor
Posts: 7
Registered: ‎01-13-2019

Re: Dataflow refresh fails on Azure SQL Data Warehouse

Hi mvogt_ilionx, We start looking into your issue and we will appreciate if you can check with you tenant admin what are the MFA (Multi Factor Authentication) your tenant has for working with Power BI and for working with Power Query Online (PQO). Moreover, whether these configurations recently changed? Thanks, Galia
Frequent Visitor
Posts: 8
Registered: ‎10-11-2018

Re: Dataflow refresh fails on Azure SQL Data Warehouse

Hi Galia,

 

Thanks for your response.

 

The MFA used is username password and SMS. I believe this is based on ADFS with microsoft account. So there is no Azure AD in place.

 

As far as i know there have been no recent changes.

 

Is this the information you are looking for?

 

 

Kind regards,

 

Matthijs

Frequent Visitor
Posts: 8
Registered: ‎10-11-2018

Re: Dataflow refresh fails on Azure SQL Data Warehouse

Hi Galia,

 

any news on this issue?

 

 

Kind regards,

 

Matthijs

Frequent Visitor
Posts: 8
Registered: ‎10-11-2018

Re: Dataflow refresh fails on Azure SQL Data Warehouse

I've retried the refresh and as of now it's working. Thanks!