Stefan Pettersson on 21 Oct 2020 11:06:20
Power BI Report Server (on-premises) and Custom Connectors
Goal: We want to use a Custom Data Connector (Denodo Power BI Custom Connector) to enable us to use ODBC with Direct Query and Windows Authentication. We understand that this isn’t supported and that only the following built-in Data Adapters are supported: https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
We have tried the built-in ODBC connector (and an ODBC driver from Denodo) instead as a workaround. However, according the URL above Direct Query isn’t supported.