# Sync Apollo to Microsoft Power BI

Automatically sync your Apollo data into Microsoft Power BI with Flatly's no-code, triggerless, turnkey integration service.

## Historical & Dynamic Data

### One-way Sync

### For Non-technical Users

[Connect Apollo to Microsoft Power BI](https://app.flatly.io/signup) [Which Apollo API does Flatly use?](https://developer.apollo.io/)

## Source: Apollo

Apollo is a leader in Sales Intelligence & Sales Engagement.

Auth: OAuth

### Available datasets
- Accounts
- Contacts
- Opportunities

## Destination: Microsoft Power BI

PowerBI reads CSV or XLSX files directly from OneDrive for Business.

Auth: OAuth

## How it works

1. **Connect Apollo**  
   Authenticate Apollo (OAuth) and Microsoft Power BI (OAuth) in the Flatly dashboard. You only have to do this once.

2. **Choose your datasets**  
   Pick which Apollo datasets to sync and set your sync frequency. The frequencies available to you depend on your Flatly [plan](/content/pricing/index.html).

3. **Data lands in Microsoft Power BI**  
   Flatly uploads your Apollo data to Microsoft Power BI automatically and refreshes it based on your sync frequency.

## Microsoft Power BI

Works with storage natively  
Flatly refreshes data in the storage platforms Power BI reads from directly.

### Supported Sources
- **Azure.** Load data from blob storage in Azure containers.
- **OneDrive.** Load data from OneDrive, both consumer and business versions.
- **Excel Online.** Load data from XLSX files in Excel Online.

> “The interface is unbelievable. Flatly is so easy to use. After years of struggling with Zapier this is life changing.”  
> Melissa Cable  
> Project Manager, Aeolidia

### Features
- **Full data refresh**  
  Maintain up-to-date flat files when any nested or bundled data changes in your source app.
- **Connection Management**  
  Manage multiple tenants, with connection health monitoring.
- **Bulk Job Management**  
  Control multiple jobs at the same time, with live progress monitoring.
- **Merged datasets**  
  Export left-joined combo objects like deals+products.
- **Write options**  
  Refresh one flat file or create a stack of timestamped versions.
- **Filterability**  
  Include only the columns or views essential for your reporting.
- **Notifications**  
  Get alerts about your syncs via email, webhooks or Slack notifications.
- **Logging**  
  Access up to one thousand log entries for your sync operations.
- **Custom Field Enrichment**  
  Get useful values in your data instead of identifiers or definitions.
- **Metadata Attachment**  
  See file statistics alongside your flat files to keep track of their origins.
- **Dark UI Mode**  
  Reduce eye strain and save energy by using our built in dark mode.
- **Programmatic Jobs**  
  Queue jobs by making API calls or agent requests.
- **Time Stamp Enrichment**  
  Get human-readable dates and times from UNIX timestamps.
- **High frequency**  
  10-minute refresh cycles mean your data store is near real-time.
- **High capacity**  
  Reliably flatten billions of cells to CSV files without hiccups.
- **Advanced Security**  
  Two-factor authentication and Destination Lock controls.
- **Stripe-powered Billing**  
  Reliable payments provider with automatic, familiar invoicing and 1% of Sales to Stripe Climate.
- **Mobile access**  
  Manage your sync operations from your phone if you are traveling.

## Connect Apollo to Microsoft Power BI

Get started today with a 14-day free trial. No credit card required. Both human and AI support are available.

[Get started](https://app.flatly.io/signup) [Learn more →](/content/faq/index.html)