Viewing Your Data in Power BI

Use SyncRange's Microsoft Excel and BigQuery exporters to sync your data, then connect it to Power BI. Both destinations work as native Power BI data sources. You can build reports and dashboards without any extra connectors.

Overview

SyncRange exports your marketing and e-commerce data to Microsoft Excel (OneDrive) or BigQuery on a schedule. Power BI can connect directly to both of these destinations. No third-party connectors are required. This approach gives you full control over your data sync schedule, the ability to combine multiple sources in one workbook or dataset, and reports that refresh based on your export schedule.

Native Data Sources

Excel and BigQuery are built-in Power BI connectors. You can add them as data sources in Power BI Desktop or the Power BI service without installing anything extra. Just sign in with your Microsoft or Google account and select your workbook or dataset.

Two Ways to Connect

Choose the destination that best fits your use case. Both work seamlessly with Power BI.

Microsoft Excel

Export your data to an Excel workbook in OneDrive with SyncRange, then connect that file to Power BI as a data source.

Best for smaller datasets and ad-hoc reporting
Easy to share and collaborate via OneDrive
Each export tab maps to a worksheet in the workbook
Power BI connects via the native Excel or OneDrive connector

Configure Microsoft Excel

BigQuery

Export your data to BigQuery with SyncRange, then connect your BigQuery dataset to Power BI.

Best for large datasets and data warehousing
Powerful SQL queries and joins
Scales to millions of rows
Power BI connects via the native BigQuery connector

Configure BigQuery

How to Set Up

Follow these steps to get your SyncRange data into Power BI.

Create Exporters in SyncRange

Set up one or more exporters to sync your data to Microsoft Excel or BigQuery. Connect your data sources (Shopify, Google Ads, Meta, etc.), configure your export destination, and choose a schedule. See Creating Exporters for details.

Let Your Data Sync

Once your exporters run, your data will appear in the selected Excel workbook or BigQuery table. Make sure at least one export has completed before connecting to Power BI.

Add a Data Source in Power BI

In Power BI Desktop, click Get data, then choose the connector that matches your SyncRange destination. Both are native and require no installation.

For Excel: Choose Excel workbook or OneDrive for Business, sign in with the same Microsoft account connected to SyncRange, and select the workbook and worksheet that contains your exported data.
For BigQuery: Choose Google BigQuery, sign in with the Google account that has access to your project, and select the dataset and table that SyncRange populated.

In the Power BI service, you can publish a report from Power BI Desktop or create a semantic model connected to the same data source.

Build Your Report

Add visuals, tables, and filters using your SyncRange data. Configure scheduled refresh in the Power BI service so your report picks up new data after SyncRange runs your exports.

Data Refresh

Your Power BI reports show data from your Excel workbooks or BigQuery tables. That data is updated by SyncRange according to your export schedule, not in real time from the source platforms.

SyncRange: Exports run on the schedule you set (daily, hourly, etc.). Check your exporter settings in SyncRange.
Power BI to Excel: Configure scheduled refresh in the Power BI service for workbooks stored in OneDrive or SharePoint. Power BI will re-read the file on your refresh schedule.
Power BI to BigQuery: Configure scheduled refresh or use DirectQuery depending on your model. Either way, you'll see the latest data that SyncRange has written to your tables after each refresh.

Tips for Best Results

Use consistent worksheet names or BigQuery table naming so your Power BI data sources stay stable when you add new exporters.
For multi-source reports, export multiple data sources to the same Excel workbook (different worksheets) or the same BigQuery dataset, then load each table into your Power BI model and relate them as needed.
For Excel, sign in to Power BI with the same Microsoft account that owns the OneDrive file SyncRange writes to.
For BigQuery, ensure the Google account used in Power BI has access to the project, dataset, and tables SyncRange populates.