Dataflow not working with Gateway

[michael_riehle]

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.

Thoughts?

[v-frfei-msft]

Hi @michael_riehle ,

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.

[michael_riehle]

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.

[michael_riehle]

Correction. None work through the gateway. SharePoint works fine.