Power BI connect to Published OData Service with Token based authentication
1
Since Mendix version 8 OData services can use custom authentication. Similar to Rest API endpoints. I am attempting to have a Power BI report connect to a Mendix OData endpoint using token-based authentication. This is so I don’t have to use a username and password. The problem I am having is not from the Mendix side but from the Power BI side. Has anyone had any luck getting Power BI to pass a token through to the OData service? Curious to see other’s experience as it would be preferable not to pass in a username and password to the OData feed using Basic Authentication. The connection options for an OData feed in Power BI are: Anonymous Windows Basic Web API Organizational account