Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Gateway Error

My data gateway (personal mode) has worked in connecting to report in web service but now getting the below error. I have reinstalled several times, restarted the gateway, etc. and still getting the same error:

 

Activity ID: eeffdd69-e77a-429c-9838-5617defc1d63
Request ID: 3da93fac-58ba-f5aa-b07d-2d727310ac93
Correlation ID: e6971ecd-e1fb-a2bd-5539-25dea0269ab8
Status code: 400
Time: Tue Feb 02 2021 12:11:09 GMT-0500 (Eastern Standard Time)
Service version: 13.0.15302.46
Client version: 2101.4.04609-train
Cluster URI: https://wabi-south-central-us-redirect.analysis.windows.net/

Need Help

10 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi Anonymous 

     

    The 400 error to me would indicate the website you are connecting to is having issues.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      What would the steps be to fix the issue? The connection is to the data gateway which connects to certain files, not a website. I've tested the gateway connection and no errors but when I try to apply the gateway for the report in the PowerBi web service I receive the error.

      • aj1973's avatar
        aj1973
        Community Champion
        5 years ago

        Hi Anonymous 

        You must have a credentials connection problem! did you try to refresh your report in Power Bi desktop?

         

  • Watsky's avatar
    Watsky
    Solution Sage
    5 years ago

    Anonymous has it ever worked for you?  If not I'm wondering if it's an issue with your firewall. See if you have port forwarding enabled for the ports used. The gateway uses outbound ports: TCP 443, 5671, 5672, and from 9350 through 9354. You can test this by opening the Gateway app and going to diagnostics and running the Network Test. 

    https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-communication#network-ports-test

     

     


    Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
    Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      It was running with no issues until recently. I've run the network test and again now, always run successfully. Within the dataset settings in the web service the gateway status is that it's running, however when I try to apply it immediately errors with this status.

      • GilbertQ's avatar
        GilbertQ
        Super User
        5 years ago

        Hi Anonymous 

         

        Do you have the latest gateway installed?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HiAnonymous ,

     

    Based on the discussion above, you have identified a number of gateway-related issues.

    I see you mentioned that your data gateway (personal mode) has worked in connecting to report in web service.I need to reconfirm with you if there is any other data source in this report.

    When you have combined Web and on premise data sources, it would be best to refresh them using the standard mode gateway.

    Then select the feature bellow when you configure your data source credentials.

    Hope it helps.

     

    Best Regards,

    Caitlyn Yan

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Correct, in the past the personal gateway has worked and connected to multiple data sources. 

       

      I have tried to use the standard gateway, and although I can set up a cloud data source I cannot connect to my local files or organizational files stored on OneDrive/SharePoint. Neither my Windows login nor OAuth2 authentication are accepted.