Power BI XMLA Integration Guides and Tutorials

Ready to get started?

Learn more:

Power BI XMLA Connectivity Solutions


A list of guides and tutorials for connecting to and working with live Power BI XMLA data.

CData Software connectivity tools provide access to live Power BI XMLA data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live Power BI XMLA data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze Power BI XMLA in Alteryx Designer
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Power BI XMLA in Amazon QuickSight
Aqua Data StudioJDBCConnect to Power BI XMLA in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Power BI XMLA Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Power BI XMLA Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Power BI XMLA in Birst
BIRTJDBCDesign BIRT Reports on Power BI XMLA
Clear AnalyticsODBCBuild Charts with Power BI XMLA in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze Power BI XMLA Data in Cognos Analytics
DBxtraODBCBuild Dashboards with Power BI XMLA in DBxtra
DomoODBCCreate Datasets from Power BI XMLA in Domo Workbench
Dundas BIODBCBuild Dashboards with Power BI XMLA in Dundas BI
Excel (on Mac OS)ODBCWork with Power BI XMLA Data in MS Excel on Mac OS X
FineReportJDBCFeed Power BI XMLA into FineReport
Google SheetsConnect CloudAccess Live Power BI XMLA in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Power BI XMLA
Infragistics RevealConnect CloudAnalyze Power BI XMLA Data in Infragistics Reval
JasperServerJDBCCreate Power BI XMLA Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Power BI XMLA in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Power BI XMLA in JReport Designer
KlipfolioConnect CloudCreate Power BI XMLA-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Power BI XMLA JDBC Driver in KNIME
LINQPadADO.NETWorking with Power BI XMLA in LINQPad
LookerConnect CloudAnalyze Power BI XMLA in Looker
Looker StudioConnect CloudCreate Reports from Power BI XMLA in Looker Studio
MetabaseConnect CloudCreate Interactive Power BI XMLA-Connected Metabase Dashboards
Microsoft Excel 365Connect CloudAccess Live Power BI XMLA Data in Excel 365
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Power BI XMLA
MicroStrategyConnect CloudConnect to Live Power BI XMLA in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Power BI XMLA in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Power BI XMLA in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Power BI XMLA in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Power BI XMLA-Connected Visualizations in Mode
OBIEEJDBCPower BI XMLA Reporting in OBIEE with the Power BI XMLA JDBC Driver
pandasPythonUse pandas to Visualize Power BI XMLA in Python
Pentaho Report DesignerJDBCIntegrate Power BI XMLA in the Pentaho Report Designer
Power BI ServiceConnect CloudVisualize Live Power BI XMLA in the Power BI Service
Qlik CloudConnect CloudCreate Apps from Power BI XMLA in Qlik Sense Cloud
QlikViewODBCConnect to and Query Power BI XMLA in QlikView over ODBC
RJDBCAnalyze Power BI XMLA in R (JDBC)
RODBCAnalyze Power BI XMLA in R (ODBC)
RapidMinerJDBCConnect to Power BI XMLA in RapidMiner
SAP Analytics CloudConnect CloudAnalyze Power BI XMLA in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Power BI XMLA
SAP Crystal ReportsJDBCPublish Reports with Power BI XMLA in Crystal Reports
SASODBCUse the CData ODBC Driver for Power BI XMLA in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Power BI XMLA in SAS JMP
SisenseJDBCVisualize Live Power BI XMLA in Sisense
Spago BIJDBCConnect to Power BI XMLA in SpagoBI
Tableau CloudConnect CloudBuild Power BI XMLA Visualizations in Tableau Cloud
TIBCO SpotfireADO.NETVisualize Power BI XMLA in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on Power BI XMLA from Spotfire Server
Zoho AnalyticsConnect CloudCreate Power BI XMLA-Connect Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous Power BI XMLA Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Power BI XMLA Replication to Amazon S3
Apache AirflowJDBCBridge Power BI XMLA Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Power BI XMLA using Apache Camel
Apache NiFiJDBCBridge Power BI XMLA Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Power BI XMLA Data in Apache NiFi
AWS GlueConnect CloudConnect to Power BI XMLA in AWS Glue Jobs
Azure Data FactoryConnect CloudImport Power BI XMLA Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous Power BI XMLA Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous Power BI XMLA Replication to Azure Synapse
CloverDXJDBCConnect to Power BI XMLA in CloverDX (formerly CloverETL)
DatabricksCData SyncAutomated Continuous Power BI XMLA Replication to Databricks
FoxProODBCWork with Power BI XMLA in FoxPro
Google AlloyDBCData SyncAutomated Continuous Power BI XMLA Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous Power BI XMLA Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Power BI XMLA Replication to Google Cloud SQL
Google Data FusionJDBCBuild Power BI XMLA-Connected ETL Processes in Google Data Fusion
HULFT IntegrateJDBCConnect to Power BI XMLA in HULFT Integrate
Informatica CloudJDBCIntegrate Power BI XMLA in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Power BI XMLA
Jaspersoft ETLJDBCConnect to Power BI XMLA in Jaspersoft Studio
Microsoft Power AutomateConnect CloudBuild Power BI XMLA-Connected Automated Tasks with Power Automate (Desktop)
Oracle Data IntegratorJDBCETL Power BI XMLA in Oracle Data Integrator
petlPythonExtract, Transform, and Load Power BI XMLA in Python
SAP HANACData SyncAutomated Continuous Power BI XMLA Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Power BI XMLA Replication to SingleStore
SnapLogicJDBCIntegrate Power BI XMLA with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous Power BI XMLA Replication to Snowflake
SQL Server Linked ServerConnect CloudConnect to Power BI XMLA as a SQL Server Linked Server
TalendJDBCConnect to Power BI XMLA and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Power BI XMLA in UiPath Studio
VerticaCData SyncAutomated Continuous Power BI XMLA Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Power BI XMLA
.NET QueryBuilderODBCRapidly Develop Power BI XMLA-Driven Apps with Active Query Builder
Apache SparkJDBCWork with Power BI XMLA in Apache Spark Using SQL
AppSheetConnect CloudCreate Power BI XMLA-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild Power BI XMLA-Connected Apps in Bubble
ChoreoConnect CloudBuild Custom Apps on Power BI XMLA Data in Choreo
ColdFusionJDBCQuery Power BI XMLA in ColdFusion Using JDBC
ColdFusionODBCQuery Power BI XMLA in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on Power BI XMLA
DevExpressADO.NETDataBind Power BI XMLA to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Power BI XMLA with Entity Framework 6
EF - LINQADO.NETLINQ to Power BI XMLA
EF - MVCADO.NETBuild MVC Applications with Connectivity to Power BI XMLA
Filemaker ProODBCBidirectional Access to Power BI XMLA from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to Power BI XMLA from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with Power BI XMLA on Linux
Google Apps ScriptConnect CloudConnect to Power BI XMLA in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Power BI XMLA Entities in Java
IntelliJJDBCConnect to Power BI XMLA in IntelliJ
JBossJDBCConnect to Power BI XMLA from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Power BI XMLA using JDBI
JRubyJDBCConnect to Power BI XMLA in JRuby
MendixConnect CloudBuild Power BI XMLA-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live Power BI XMLA into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Power BI XMLA in Node.js (via Connect Cloud)
NodeJSJDBCQuery Power BI XMLA through ODBC in Node.js
OutSystemsConnect CloudCreate Power BI XMLA-Connected Enterprise Applications in OutSystems
PHPODBCNatively Connect to Power BI XMLA in PHP
PowerBuilderADO.NETConnect to Power BI XMLA from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for Power BI XMLA in PyCharm
PythonODBCConnect to Power BI XMLA in Python on Linux/UNIX
RubyODBCConnect to Power BI XMLA in Ruby
RunMyProcessConnect CloudConnect to Power BI XMLA in RunMyProcess
RunMyProcess DSECJDBCConnect to Power BI XMLA in DigitalSuite Studio through RunMyProcess DSEC
ServoyJDBCBuild Power BI XMLA-Connected Apps in Servoy
Spring BootJDBCAccess Live Power BI XMLA Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Power BI XMLA in Python
TomcatJDBCConfigure the CData JDBC Driver for Power BI XMLA in a Connection Pool in Tomcat
UnqorkConnect CloudCreate Power BI XMLA-Connected Applications in Unqork
VCL App (RAD Studio)FireDACBuild a Simple VCL Application for Power BI XMLA
WebLogicJDBCConnect to Power BI XMLA from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top