Credentialed, live access to enterprise systems for ChatGPT, Claude, Databricks Genie, and MCP agents — through one governed endpoint, with context and access policies intact.

CData's inclusion in the 2025 report underscores the growing recognition of our innovative solutions and our ability to address the evolving demands of modern data integration.

Palantir Technologies has expanded its relationship with CData's Embedded business unit to enhance data connectivity in Palantir Foundry, enabling users to connect to hundreds of data sources through CData's embedded connectors.

Join thousands of engineers building on CData

Sign up for our limited series covering useful prompts, tips, and future CData MCP releases that will make Claude your undisputed work bestie.

CData Connect AI is now available in the ChatGPT Directory. Bring your enterprise data directly into your chats.

CData's developer community connects thousands of data professionals who share solutions, best practices, and expertise for integrating enterprise data sources through collaborative forums and comprehensive resources.

State of AI Data Connectivity Report: 2026 Outlook Based on research with 200+ data & AI leaders and insights from AI pioneers at Microsoft and AWS, this report is the first to examine how data integration maturity drives AI success.

Join data leaders, AI innovators, and CData experts to explore the future of enterprise data infrastructure. Discover how to build AI-ready foundations, deploy intelligent agents, and transform your organization's data strategy.

Credentialed, live access to enterprise systems for ChatGPT, Claude, Databricks Genie, and MCP agents — through one governed endpoint, with context and access policies intact.

CData's inclusion in the 2025 report underscores the growing recognition of our innovative solutions and our ability to address the evolving demands of modern data integration.

Join thousands of engineers building on CData

Sign up for our limited series covering useful prompts, tips, and future CData MCP releases that will make Claude your undisputed work bestie.

CData Connect AI is now available in the ChatGPT Directory. Bring your enterprise data directly into your chats.

Visualize Live Avro Data in Power BI (via CData Connect AI)

Jerod Johnson
Director, Technology Evangelism

Use the CData Power BI Connector and CData Connect AI to integrate live Avro data into custom reports in Power BI.

Power BI transforms your company's data into rich visuals for you to collect and organize so you can focus on what matters to you. When paired with CData Connect AI, you get access to Avro data for visualizations, dashboards, and more. This article shows how to use CData Connect to create a live connection to Avro, connect to Avro data from Power BI and then create reports on Avro data in Power BI.

Configure Avro Connectivity for Power BI

Connectivity to Avro from Power BI is made possible through CData Connect AI. To work with Avro data from Power BI, we start by creating and configuring a Avro connection.

Log into Connect AI, click Sources, and then click Add Connection

Select "Avro" from the Add Connection panel

Enter the necessary authentication properties to connect to Avro. Connect to your local Avro file(s) by setting the URI connection property to the location of the Avro file.
Click Save & Test
Navigate to the Permissions tab in the Add Avro Connection page and update the User-based permissions.

With the connection configured, you are ready to connect to Avro data from Power BI.

Query Avro Tables

Follow the steps below to build a query to pull Avro data into the report:

Open Power BI Desktop and click Get Data -> Online Services -> CData Connect AI and click "Connect"
Click "Sign in" and authenticate with your CData Connect AI account
After signing in, click "Connect"
Select tables in the Navigator dialog
Click Load to establish the connection to your Avro data from Power BI

Create Avro Data Visualizations

After connecting to the data into Power BI, you can create data visualizations in the Report view by dragging fields from the Fields pane onto the canvas. Select the dimensions and measures you wish to visualize along with the chart type.

Visualizing data in Power BI (Salesforce data is shown)

Click Refresh to synchronize your report with any changes to the data.

Live Access to Avro Data from Data Applications

With CData Connect AI you have a direct connection to Avro data from Power BI. You can import more data, create new visualizations, build reports, and more — all without replicating Avro data.

To get SQL data access to hundreds of SaaS, Big Data, and NoSQL sources (including Avro) directly from your on-premise BI, reporting, ETL and other data applications, visit the CData Connect AI page and start a free trial.

Ready to get started?

Learn more about CData Connect AI or sign up for free trial access:

Free Trial

CData is the data layer that makes AI work in production—live connectivity and replication across hundreds of the most critical enterprise sources, semantic context, and built-in governance. Powering AI for Databricks, Microsoft, Google, Palantir, and 10,000+ customers worldwide.