Forum Discussion

spehe's avatar
spehe
Icon for Helper I rankHelper I
3 years ago

Adding Odata connection to on-premise Gateway fails with error message about credentials

Hello,

I have made report in PowerBI Desktop that works fine. Also, when I paste the Odata url into a web browser, it returns data correctly. But after publishing the report on PowerBI.com and wanting to set a scheduled update, it will not add the connection to the Gateway.

  Any help would be deeply appreciated.

Need Help

10 Replies

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    3 years ago

    Hey spehe ,
    can you create/add this one connection in your Service tenant under Gateway connections?

    Reagrds

  • spehe's avatar
    spehe
    Icon for Helper I rankHelper I
    3 years ago

    Hi Sergej,

    where do I find the Service tenant?

    • sergej_og's avatar
      sergej_og
      Icon for Super User rankSuper User
      3 years ago

      Your Power BI Service is meant by that.
      Sorry for the inaccurate wording.
      In your Service you can add new connections to your gateway. I hope you have already one running.

      • spehe's avatar
        spehe
        Icon for Helper I rankHelper I
        3 years ago

        Aaah! Ok, then I understand. Actually, that is exactly what I cannot do, that's when I get the error message.

  • spehe's avatar
    spehe
    Icon for Helper I rankHelper I
    3 years ago

    This is really strange.
    PowerBI Desktop -> Odata -> NAV 2017 - OK

    Web browser -> Odata -> NAV 2017 - OK

    PowerBI.com -> SQL query -> NAV 2017 - OK

    PowerBI.com -> Odata via Gateway -> NAV 2017 - "InvalidConnectionCredentials".

     

    I have been looking everywhere, without any luck. Has anyone successfully set up a connection from PowerBI.com to a NAV 2017, using an on-prem Data Gateway? If so, what should I look for? Any help is deeply appreciated.