CData Power BI Connector for FreshBooks 2019 - Online Help
Questions / Feedback?

CData Power BI Connector for FreshBooks 2019

CData Power BI Connector for FreshBooks 2019 - Build 19.0.7354


The CData Power BI Connector for FreshBooks 2019 offers self-service integration with Microsoft Power BI. The connector facilitates live access to FreshBooks data in Power BI from the Get Data window. The connector also provides direct querying to visualize and analyze FreshBooks data.

Getting Started

See Getting Started for a guide to create the FreshBooks data source and connect from the Get Data window.

Using the Data Connector

See Using the Connector for a walk-through of creating reports that query FreshBooks in real time.

SQL Compliance

See SQL Compliance for a syntax reference and code examples outlining the supported SQL.

Caching Data

The connector supports Power BI's ability to embed data in a report, but it also supports robust caching. See Caching Data to configure replication and caching for a range of scenarios common to remote data access. Configurations include:

  • Autocache: Automatically cache data to a lightweight database. Save data for later offline use or enable fast reporting from the cache.
  • Replication: Copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, and so on. The replication commands allow for intelligent incremental updates to cached data.
  • No caching: Work with remote data only. No local cache file is created.

Data Model

See Data Model for information on the available database objects and how to use SQL to work with FreshBooks APIs. This section provides more detailed information on querying specific FreshBooks entities.

Collaborative Query Processing

The connector can enhance the data source's capabilities with additional client side processing, when needed, which enables analytic summaries of data such as SUM, AVG, MAX, MIN, and so on.

See SupportEnhancedSQL, in the Connection section, for more information.

Connection String Options

The Connection properties describe the various options that can be used to establish a connection.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0