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.
Hi. Here is the contents of the CSV file with the error:
|Run time||14/02/2019 14:26:15|
|Dataflow refresh status||Failed|
|Start time||14/02/2019 14:26:15|
|End time||14/02/2019 14:26:16|
|Entity refresh status||Failed|
|Error||Error: 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