Power BI XMLA Integration Guides and Tutorials



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

CData Software's connectivity tools enable users to connect directly to live Power BI XMLA data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on 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 (ODBC)
Alteryx DesignerConnect CloudWork with Live Power BI XMLA Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Power BI XMLA Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live Power BI XMLA data into Amazon SageMaker Canvas
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 Data 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 Data in Looker
Looker StudioConnect CloudCreate Reports from Power BI XMLA Data in Looker Studio
MetabaseConnect CloudCreate Interactive Power BI XMLA-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live Power BI XMLA Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live Power BI XMLA Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Power BI XMLA
MicroStrategyConnect CloudConnect to Live Power BI XMLA Data 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 Data in the Power BI Service
Power PivotConnect CloudAccess Power BI XMLA Data in Microsoft Power Pivot
Power QueryConnect CloudAccess Power BI XMLA Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from Power BI XMLA Data 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
RedashConnect CloudQuery, Visualize, and Share live Power BI XMLA Data in Redash
SAP Analytics CloudConnect CloudAnalyze Power BI XMLA Data 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 (JDBC)
SAP Crystal ReportsConnect CloudPublish Reports with Power BI XMLA in Crystal Reports (Connect Cloud)
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
SAS ViyaConnect CloudAnalyze Live Power BI XMLA Data in SAS Viya
SisenseJDBCVisualize Live Power BI XMLA in Sisense
Spago BIJDBCConnect to Power BI XMLA in SpagoBI
TableauConnect CloudVisualize Power BI XMLA in Tableau Desktop (Connect Cloud)
Tableau CloudConnect CloudBuild Power BI XMLA Visualizations in Tableau Cloud
ThoughtSpotConnect CloudModel, Search, and Visualize Live Power BI XMLA Data in ThoughtSpot
TIBCO SpotfireADO.NETVisualize Power BI XMLA in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize Power BI XMLA Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Power BI XMLA from Spotfire Server
Zoho AnalyticsConnect CloudCreate Power BI XMLA-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to Power BI XMLA Data in Airbyte ELT Pipelines
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 CassandraCData SyncAutomated Continuous Power BI XMLA Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous Power BI XMLA Replication to Apache Kafka
Apache NiFiJDBCBridge Power BI XMLA Connectivity with Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with Power BI XMLA Data 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)
CouchbaseCData SyncAutomated Continuous Power BI XMLA Replication to Couchbase
CSVCData SyncAutomated Continuous Power BI XMLA Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous Power BI XMLA Replication to Databricks
ETL ValidatorJDBCHow to Work with Power BI XMLA in ETL Validator
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
Google Data FusionJDBCBuild Pipelines with Live Power BI XMLA Data in Google Cloud Data Fusion (CData Connect Cloud)
Heroku / Salesforce ConnectCData SyncReplicate Power BI XMLA for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Power BI XMLA in HULFT Integrate
IBM DB2CData SyncAutomated Continuous Power BI XMLA Replication to IBM DB2
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 AccessCData SyncAutomated Continuous Power BI XMLA Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Power BI XMLA Replication to Azure SQL
Microsoft Power AutomateConnect CloudBuild Power BI XMLA-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous Power BI XMLA Replication to MongoDB
MySQLCData SyncAutomated Continuous Power BI XMLA Replication to MySQL
Oracle Data IntegratorJDBCETL Power BI XMLA in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Power BI XMLA Replication to Oracle
petlPythonExtract, Transform, and Load Power BI XMLA in Python
PostgreSQLCData SyncAutomated Continuous Power BI XMLA Replication to PostgreSQL
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 (JDBC)
SnapLogicConnect CloudIntegration with Power BI XMLA Data in SnapLogic (Connect Cloud)
SnowflakeCData SyncAutomated Continuous Power BI XMLA Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Power BI XMLA Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to Power BI XMLA Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous Power BI XMLA Replication to SQLite
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
WorkatoConnect CloudBuild Automated Workflows with Live Power BI XMLA Data in Workato
ZapierConnect CloudBuild Automated Power BI XMLA-Connected Workflows in Zapier

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
AWS LambdaJDBCAccess Live Power BI XMLA Data in AWS Lambda
AxiosConnect CloudBuild Power BI XMLA-Connected Web Apps with Axios and CData Connect Cloud
.NET ChartsADO.NETDataBind Charts to Power BI XMLA
.NET QueryBuilderODBCRapidly Develop Power BI XMLA-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with Power BI XMLA
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
C++BuilderODBCDataBind Controls to Power BI XMLA Data in C++Builder
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
DelphiODBCDataBind Controls to Power BI XMLA Data in Delphi
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 Data 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
JitterbitConnect CloudIntegrate with Live Power BI XMLA Data in Jitterbit
JRubyJDBCConnect to Power BI XMLA in JRuby
MendixConnect CloudBuild Power BI XMLA-Connected Apps in Mendix (Connect Cloud)
MendixJDBCBuild Power BI XMLA-Connected Apps in Mendix (JDBC)
Microsoft Power AppsConnect CloudIntegrate Live Power BI XMLA Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Power BI XMLA Data in Node.js (via Connect Cloud)
NodeJSODBCQuery Power BI XMLA through ODBC in Node.js
OutSystemsConnect CloudCreate Power BI XMLA-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess Power BI XMLA in PHP through Connect Server
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
ReactConnect ServerBuild Dynamic React Apps with Power BI XMLA Data
RubyODBCConnect to Power BI XMLA in Ruby
RunMyProcessConnect CloudConnect to Power BI XMLA Data in RunMyProcess
RunMyProcess DSECJDBCConnect to Power BI XMLA in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to Power BI XMLA in SAPUI5 MVC Apps
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)ODBCBuild 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

Ready to get started?