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

[spehe]

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.

[spehe]

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.

[spehe]

Hi Sergej,

where do I find the Service tenant?

[sergej_og]

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]

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

[sergej_og]

Ok, do you have access to a person who can add one new connection to the gateway?
You are not an admin in Service, right?
Also you can ask an Service admin to give you permissions to use your Service gateway. With such permissions you can add new conncetions to the gateway.

[spehe]

Yes I am an Admin for PowerBI, and I can create a new connection but it will throw the same error message.

[sergej_og]

ok, you are here?

and then here to add new one?

And then you get after giving credentials an error?

Regards

[spehe]

Yes.

[sergej_og]

It looks to me like there is a problem on the source side...concering error message.

[sergej_og]

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

Reagrds