Does anyone know if it is possible to use power bi in the cloud and have it pass credentials through to a power bi gateway on premise to connect to “dremio software” (dremio on-prem)? The goal is to have the users account that they login to power bi cloud with do the query via the gateway and not as another account defined on the pbi gateway.
Using inbound impersonation should allow the service user from the gateway to query as the original user. However, this is an EE feature. Leveraging just OOTB CE features I do not think this is possible.
I am not sure that it the case.
Inbound Impersonation | Dremio Documentation
Dremio supports inbound impersonation for Java Database Connectivity (JDBC) connections for Hadoop Distributed File System (HDFS) and Hive sources as well as for Dremio-to-Dremio sources.
The pbi gateway is using an odbc connection. The statement from the impersonation page implies that it only works with JDBC.
That’s a good point. I know a customer who did a similar thing with Tableau, but that’s JDBC. I’ll speak with the developers about this. The powerbi connector is leveraging our legacy odbc driver and, based on internal tickets does support impersonation. I’ll get back to you.
The Dremio Power BI connector supports impersonation via SSO on both the gateway and Powerbi Server. This is not possible via the generic ODBC connection but is via the official connector. Despite being on Software you need to leverage the Dremio Cloud connector in PowerBI Enabling Single Sign-On (SSO) on Published Reports Created with the Dremio Software Connector | Dremio Documentation. This requires at least version 24