We're excited to announce four new integrations between Dagster and some of the most widely used business intelligence (BI) tools: Looker, Power BI, Tableau, and Sigma. These integrations are designed to provide deeper insights into how your data flows from source to dashboard, making it easier to manage and understand your data ecosystem.
A complete asset graph with real end-to-end pipelines
Data assets orchestrated by Dagster often power dashboards and other assets in business intelligence (BI) tools like Looker, Power BI, and Tableau. The lineage between these BI assets and the assets they depend on is crucial for understanding where dashboard data comes from, how data is being used, and debugging issues when they arise.
By representing BI assets directly in the Dagster asset graph, these integrations provide a clear picture of how data flows throughout your organization and break down the silos between your analytics engineers and data analysts. If a Dagster-managed asset becomes stale or encounters a data quality issue, you can now immediately understand the downstream impact all the way to the BI tool. This visibility helps ensure that upstream data asset changes are accurately reflected in dashboards and reports.
With the addition of capabilities to trigger compute processes in your BI tools for cached assets in Looker, Tableau, Sigma, and PowerBI, you no longer have to rely on chaining together scheduled processes to ensure that BI assets are updated, cached, and distributed to your key stakeholders. You can now build truly integrated pipelines spanning from source data to the visualization layer.
These integrations also make Dagster a one-stop shop for learning about data assets, offering users a complete view of their analytics environment. For data consumers, this means having insights not just into the tables in their warehouse but also into the dashboards and reports that depend on them.
What's being released
That's why we're excited to introduce four new integrations, each designed to streamline your data workflows and make your BI tools even more powerful:
Power BI: Our Power BI integration lets you Sigma: The Dagster Sigma integration—available in a fully featured preview release—lets you bring datasets and workbooks into the Dagster asset graph. This gives your data teams better visibility into how your Sigma assets are leveraging data across the organization and gains visibility into downstream data usage. Get started with this demo and the docs.
Tableau: With our Tableau integration, you can pull data sources, sheets, and dashboards into Dagster as assets. This integration allows for seamless orchestration of data refreshes, ensuring that updates to upstream data are reflected in your Tableau dashboards. (Demo, docs.)
Looker: Our Looker integration connects your Looker model dashboards and views with the Dagster data catalog and global asset lineage graph. Additionally, this integration supports materializing persistently derived tables (PDTs) with just a few lines of code. (Demo, docs.)
These integrations are not only about representing BI assets in Dagster—they also enable you to orchestrate updates, ensuring your BI tools reflect the most current data from upstream sources. This makes managing data refreshes simpler and more reliable without relying on clunky cron jobs or manual updates.
What's Next?
We're already working on several improvements to make these integrations even better, including:
- Enhanced User Experience: Expect UX improvements to the asset graph and asset details pages, such as deep linking directly back to definitions in your BI tools. This will make navigating between Dagster and your BI environment even easier.
- Expanding Integrations: We're also exploring partnerships with other BI tools. Let us know if there's a BI integration you're excited about
- Integration Toolkit: We're considering creating a toolkit or guide that gives developers and data teams more control and flexibility for creating their own integrations.
These future enhancements are all part of our mission to help organizations build productive, scalable data platforms by offering a unified control plane for their data and a single pane of glass to visualize it.
Get Started Today
All four integrations are available now, and we're eager to hear your feedback. Whether you're using Looker, Power BI, Tableau, or Sigma, these integrations will help you better understand your data flows and keep your BI assets in sync with your data pipelines.
Dive into the documentation to get started, and let us know how we can continue to improve your experience with Dagster and your BI tools!
.png)
.jpg)
