Back to home
Destinations

Push your API data
directly to Power BI

No export files. No manual refresh. Run a workflow in API Import and rows land in your Power BI push dataset — ready to visualize.

Azure AD OAuthPush DatasetsAuto-create datasetsScheduled refresh
How it works

Three steps to your first row in Power BI

Choose Power BI as your destination, authorize with Azure AD, select a workspace and dataset, and run.

01

Choose Power BI as your destination

In the workflow editor, switch the destination from Google Sheets™ to Power BI. Works on new and saved workflows once you've authorized your Azure AD account.

Destination
Power BI
Selected
02

Authorize with Azure AD

API Import prompts an Azure AD OAuth flow. Sign in once and the token is stored for scheduled runs — no repeated logins needed.

Azure AD sign-in
user@company.onmicrosoft.com
03

Select workspace and dataset — then run

Pick a workspace and dataset from dropdowns. API Import fetches from your API, maps fields, and pushes rows in batches of up to 10,000. Schedule it to keep your reports fresh.

Result
name
value
date
Product A
$4,200
2026-05
Product B
$3,850
2026-05
Product C
$6,100
2026-05
Dataset modes

Control exactly how data lands

Each workflow lets you choose whether API Import creates the dataset for you or writes into one you already manage.

Auto-create dataset
API Import handles the setup.
If the named dataset doesn't exist in the selected workspace, API Import creates a Push dataset with all-string columns automatically. Just name it and run.
  • Creates dataset if missing
  • All columns created as String
  • Inserts new rows
  • Never deletes existing rows
Existing dataset
Write to a dataset you manage.
API Import appends rows to the named table in your existing Push dataset. The dataset and table must already exist and be of Push type.
  • Requires Push-type dataset and table to exist
  • Inserts new rows
  • Leaves schema untouched
  • Never deletes existing rows
Getting started

Set up Power BI in four steps

You'll need a Power BI account with Pro, Premium Per User, or Premium capacity to use Push Datasets.

1
Ensure Push Datasets are enabled
Power BI Push Datasets require Power BI Pro, Premium Per User, or Premium capacity. If you're unsure, check with your Power BI admin — the Push Dataset API must be accessible from your account.
2
Choose or create a workspace
You can use a shared team workspace or your personal "My workspace" — both appear in the workspace dropdown after you connect. If you want teammates to access the dataset, use a shared workspace; My workspace is visible only to you.
3
Connect in API Import
In your workflow, choose Power BI as the destination and click "Authorize." Complete the Azure AD sign-in. API Import then lists your available workspaces and datasets.
4
Name your dataset and table — then run
Type the dataset name and table name. If the dataset doesn't exist yet, API Import creates it automatically. Run the workflow — rows appear in Power BI immediately, ready to build reports on.
Visit powerbi.microsoft.com

Ready to ship data to Power BI?

Install API Import for Google Sheets™ and connect your Power BI workspace in minutes.

Install free on Google Sheets™Read the docs