I have a couple dataflows. Some connect to SharePoint and some connect to our SQL Server through a gateway. It appears none work when refreshing. I get an error Error: An internal error occurred ... Received error payload from gateway service with ID 692745: An exception encountered while creating the target data source.
Based on my test, I cannot reproduce your issue here. Could you please check whether you can refresh the data in power bi desktop by connecting to the sql server? Or you can just update your gateway to check again.
Community Support Team _ Frank If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
What can I do to help you reproduce? Do you need the full error?
End time
Entity refresh status
Error
25/06/2019 09:53:45
Failed
Error: An internal error occurred... RootActivityId = 0bc788cc-781b-449e-a02b-5169df863836.Param1 = Received error payload from gateway service with ID 692745: An exception encountered while creating the target data source. Request ID: 2b2b5369-41a8-71e5-ed96-e7c970ba49f0.
25/06/2019 09:53:45
Failed
Error: One or more upstream operations failed... RootActivityId = 0bc788cc-781b-449e-a02b-5169df863836 Request ID: 2b2b5369-41a8-71e5-ed96-e7c970ba49f0.
25/06/2019 09:53:45
Failed
Error: One or more upstream operations failed... RootActivityId = 0bc788cc-781b-449e-a02b-5169df863836 Request ID: 2b2b5369-41a8-71e5-ed96-e7c970ba49f0.
25/06/2019 09:53:45
Failed
Error: One or more upstream operations failed... RootActivityId = 0bc788cc-781b-449e-a02b-5169df863836 Request ID: 2b2b5369-41a8-71e5-ed96-e7c970ba49f0.
