Microsoft Dynamics 365 on-prem Odata OAuth2 authentication fails in Power BI services

[ahim92]

Hello,

I succesfully connect to on-prem Dynamics 365 data source in Power BI desktop via Odata as OAuth2 authentication method. After publishing report in PBI services I am trying to configure data gateway for this data source using the same method in order to be able to schedule regulat refreshs. There is the following error when trying to authenticate via data gateway: The token service reported by the resource is not trusted. 

Status code: 400
Error Code: DM_GWPipeline_Client_OAuthTokenLoginFailedError

Any suggestion?

Best regards,

Miha

[v-deddai1-msft]

Hi @ahim92 ,

Would you please  try to confirm if your gateway is configured well in the your server? You may also need to refer to the following document: https://nishantrana.me/2019/08/24/connect-to-dynamics-365-web-api-using-oauth-2-0-client-credentials....

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

Best Regards,

Dedmon Dai