Skip to main content
Microsoft Idea

Power BI

Planned

Dremio/Power BI Service Support SSO through DirectQuery

Vote (143) Share
Chris O'Brien's profile image

Chris O'Brien on 14 Jun 2019 22:52:50

Dremio serves as our corporate data as a service platform, Power BI Desktop with Dremio works fine but in order for our users to use PowerBI Service we need Power BI to support SSO connections for Dremio. We are looking for SSO (Pass through) connectivity from PowerBI Service to Dremio. Use of an on-premise Gateway would require a single service account and will not work due to limiting security access controls to our data. Please consider adding this support for Dremio.

Dremio should be included with these SSO DirectQuery sources(bottom of page).

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources

Administrator

AAD SSO over Dremio Cloud is Planned. 

Comments (5)
Chris O'Brien's profile image Profile Picture

Joshua Wallace on 17 Jul 2020 15:46:36

RE: Dremio/Power BI Service Support SSO through DirectQuery

At my company need this same support for a few different custom connectors. Dremio & TIBCO(R) Data Virtualization. We will have over 100,000 different users globally that would need access to different data sources and due to the Data Gateway requirements for Data Sources we would have to create/manage over 500,000 different data sources and service accounts mapping to each user and each database.

We would like to see option to allow end-user to enter their own Credentials and allow them to store them in the service. Have the data stored on the gateway tied to the user's profile.

Chris O'Brien's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:15:44

RE: Dremio/Power BI Service Support SSO through DirectQuery

This ist also related to Apache Drill. Dremio uses Apache Drill. So bring Apache Drill for Power BI in place enables also Dremio. Azure Synapse already has support for Apache Drill.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37037458-direct-query-for-apache-drill

Chris O'Brien's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:26

RE: Dremio/Power BI Service Support SSO through DirectQuery

Vote up.

https://123project.ir/%d8%a7%d9%86%d8%ac%d8%a7%d9%85-%d9%be%d8%b1%d9%88%da%98%d9%87-%d9%87%d8%a7%db%8c-%d9%85%d8%aa%d9%84%d8%a8/

Chris O'Brien's profile image Profile Picture

Madhavi Pamulapati on 05 Jul 2020 23:52:22

RE: Dremio/Power BI Service Support SSO through DirectQuery

Yes its is highly important

Chris O'Brien's profile image Profile Picture

Power BI User on 05 Jul 2020 23:51:03

RE: Dremio/Power BI Service Support SSO through DirectQuery

This is an essential feature for Dremio and PowerBi users.

At my company we currently prevent 2000+ Dremio users from using PowerBI because of a missing integration offered by Microsoft. We use Tableau instead (although we would like to use PowerBI), the integration works perfectly on Tableau both client- and server-side.

I know about the requirement to connect Dremio to PowerBI from other larger companies.