Learn more
 

CData Software - Knowledge Base

Recent XML Excel Articles

How to update XML from Excel

This article explains how to transfer data from Excel to XML using the Excel Add-In for XML.

Use the CData ODBC Driver for XML in Microsoft Power Query

You can use the CData XML ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import XML Files into Microsoft Power Query.

Use the CData ODBC Driver for Power BI XMLA from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Power BI XMLA to connect to Power BI XMLA from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Power BI XMLA in Excel.

Explore Geographical Relationships in XML with Power Map

Create data visualizations with XML Files in Power Map.

Import and Visualize Power BI XMLA in Power View

Create data visualizations based on Power BI XMLA in Excel.

Operational Reporting on Excel from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Excel.

Import XML into Microsoft Power Query

The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access XML Files. In this article, you will use the OData format to import XML Files into Microsoft Power Query.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Work with Live Power BI XMLA in Power Query

Use CData Connect Cloud to connect to Power BI XMLA and work with live Power BI XMLA in Microsoft Power Query.

Access Live Power BI XMLA in Excel (Desktop)

Use CData Connect Cloud to gain access to live Power BI XMLA from your Excel spreadsheets.

Author and Share Power BI Reports on Real-Time Power BI XMLA

Use the CData ODBC Driver for Power BI XMLA to visualize Power BI XMLA in Power BI Desktop and then upload to the Power BI service.

Author and Share Power BI Reports on Real-Time XML

Use the CData ODBC Driver for XML to visualize XML Files in Power BI Desktop and then upload to the Power BI service.

Use the CData ODBC Driver for XML from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for XML to connect to XML Files from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring XML Files in Excel.

Access Live Power BI XMLA in Excel 365 Online (Excel for the web)

Connect to Power BI XMLA from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Operational Reporting on Excel Online from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Excel Online.