cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AdamWidi Frequent Visitor
Frequent Visitor

Power BI Dataflows fails to refresh to On-Premesis SQL Server through Data Gateway

I have built a dataflow that connects to an on-prem SQL Server through the data gateway.  The designer works fine and I can build the dataflow, however the refresh fails with the following message. 

Error: Internal error Request ID: 10bc8b2f-e10c-4873-0c14-a737feba8d00 Activity ID: d19dbb59-dbb5-42a9-8bde-624532547291

 

Note, a PowerBI dataset can successfully refresh through the same data gateway connection.

 

4 REPLIES 4
Super User
Super User

Re: Power BI Dataflows fails to refresh to On-Premesis SQL Server through Data Gateway

Hi there

when you download the CSV file with the error, is there anything else in the other fields?

And do other dataflows refresh successfully?
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
AdamWidi Frequent Visitor
Frequent Visitor

Re: Power BI Dataflows fails to refresh to On-Premesis SQL Server through Data Gateway

Hi.  Here is the contents of the CSV file with the error:

 

Run time14/02/2019 14:26:15
Dataflow nameWideWorldImporters
Dataflow refresh statusFailed
Entity nameCity
Start time14/02/2019 14:26:15
End time14/02/2019 14:26:16
Entity refresh statusFailed
ErrorError: Internal error Request ID: 10bc8b2f-e10c-4873-0c14-a737feba8d00 Activity ID: d19dbb59-dbb5-42a9-8bde-624532547291

 

I was able to get a dataflow that sources from an Azure SQL Database to refresh. 

The issue is with the on-premises source.

I did install the latest data gateway and confirmed that it works for Power BI Datasets.

 

Let me know if you need additional information.

 

Thanks, Adam Widi

Super User
Super User

Re: Power BI Dataflows fails to refresh to On-Premesis SQL Server through Data Gateway

Hi there

Does your account have multi factor authentication enabled?
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Highlighted
AdamWidi Frequent Visitor
Frequent Visitor

Re: Power BI Dataflows fails to refresh to On-Premesis SQL Server through Data Gateway

No, we do not have multi factor authentication enabled at the moment.

 

Thanks, Adam