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.
Explore this interactive demo and see how Dremio's Intelligent Lakehouse enables Agentic AI
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.
Deploy agentic analytics directly on Apache Iceberg data with no pipelines and no added overhead.
Hadoop modernization on AWS with Dremio represents a significant leap forward for organizations looking to leverage their data more effectively. By migrating to a cloud-native architecture, decoupling storage and compute, and enabling self-service data access, businesses can unlock the full potential of their data while minimizing costs and operational complexity.
With lakeFS, you version everything: Iceberg tables, images, models, logs. With Dremio, you query and analyze it all, structured or not, at scale. Together, they bring Git-style control and interactive querying to your data lake, so you can build more intelligent, version-aware workflows without sacrificing flexibility or performance.
Described by Microsoft as a “no-compromise data lake”, ADLS Gen 2 extends the capabilities of Azure Blob Storage and is optimized for large scale analytics workloads.
