Get Started Free
No time limit - totally free - just the way you like it.Sign Up Now
As organizations store more data in cloud data lakes, data teams must provide access to that data for technical and non-technical data consumers. The Dremio Open Data Lakehouse platform provides easy and direct access to the data lake without the need for complex ETL pipelines or data copies, and it connects with Microsoft Power BI to give data consumers at every level of the organization the power and freedom to explore a consistent and up-to-date view of their data.
Previously, customers using Power BI to connect to Dremio needed to use Power BI gateway, an application that enables connections to various on-premises data sources without having to move the data. Power BI gateway introduced several inefficiencies. Administrators needed to add users and maintain multiple gateways which became a bottleneck for access to on-premises data sources. With this solution, all end users leveraged the administrator’s ID, and it was difficult to track queries at the individual level. Finally, the business accrued additional costs from Virtual Machines (VMs) dedicated to running Power BI Gateway.
Dremio customers love the benefits they get using Power BI with Dremio, but they don’t like the costs and complexities associated with connecting them via Power BI gateway.
Today, we are pleased to announce an update to the Dremio connector for Power BI that allows customers to connect directly to Dremio without the need for an on-premises Power BI gateway. When users interact with a report, Power BI sends SQL queries to their Dremio cluster. The connector enables analysts to create lightning-fast reports directly on their data lakes without waiting for data imports or cache refreshes.
Follow the steps below and connect Power BI to your Dremio cluster without an on-premise gateway.
Before we get started, you will need to ensure you have the following:
In this example, we will be connecting Power BI to your Dremio Software cluster.
Dremio’s open lakehouse platform is available as a fully managed cloud service with a forever-free tier. Dremio Cloud makes deploying an open data lakehouse architecture as easy as a cloud data warehouse. You can spin up Dremio Cloud in your AWS account and explore your data lake in minutes. Get started today.
For more information on how to connect Power BI to Dremio, please visit our docs page.