Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dataflow not working with Gateway

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?

Dataflow

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      What can I do to help you reproduce? Do you need the full error?

       

      End timeEntity refresh statusError
      25/06/2019 09:53:45FailedError: 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:45FailedError: One or more upstream operations failed... RootActivityId = 0bc788cc-781b-449e-a02b-5169df863836 Request ID: 2b2b5369-41a8-71e5-ed96-e7c970ba49f0.
      25/06/2019 09:53:45FailedError: One or more upstream operations failed... RootActivityId = 0bc788cc-781b-449e-a02b-5169df863836 Request ID: 2b2b5369-41a8-71e5-ed96-e7c970ba49f0.
      25/06/2019 09:53:45FailedError: One or more upstream operations failed... RootActivityId = 0bc788cc-781b-449e-a02b-5169df863836 Request ID: 2b2b5369-41a8-71e5-ed96-e7c970ba49f0.