How to Push Power BI Data Into SharePoint Using Power Automate

Learn how to send data directly from a Power BI report into a SharePoint list using Power Automate — all powered by JSON!
In this step-by-step tutorial, I’ll show you the exact method for extracting Power BI table data, converting it into clean JSON, and passing that data into a SharePoint List using an automated flow. Whether you're building dashboards, operational apps, or automating your data ecosystem, this walkthrough gives you the full Power BI → Power Automate → SharePoint pipeline.

🚀 What You’ll Learn in This Video

In this tutorial, we’ll walk through:

1️⃣ Preparing Your Data in Power BI

How to structure your Power BI table for export

How to use the Performance Analyzer to capture DAX queries

How to extract clean JSON from Power BI using “Copy Query”

Tips to avoid blank rows, column mismatch errors, and formatting issues

2️⃣ Building the Power Automate Flow

Creating an Instant Cloud Flow or Automated Flow

Parsing JSON using the Parse JSON action

Looping through JSON records

Mapping fields into a SharePoint list

Creating new SharePoint list items dynamically

Error handling and validation techniques

3️⃣ Sending Data Into SharePoint

How to map Power BI fields to SharePoint columns

How to handle Lookups, Choice fields, Person fields, and more

Avoiding common SharePoint API errors

Best practices for batch updates vs. single insert actions

4️⃣ BONUS: Re-running the Flow Without Duplicates

How to build a “clean insert” pattern

Optional: Delete SharePoint list records before repopulating

Optional: Upsert logic using "Update Item" instead of "Create Item"

💡 Why This Tutorial Matters

Manually exporting Power BI data into SharePoint is slow, error-prone, and painful.
This method gives you:

✔ Automated pipelines
✔ Real-time SharePoint updates
✔ Cleaner workflows for Power Apps & dashboards
✔ A repeatable JSON-driven process you can reuse in ANY project

This is the same technique used in enterprise workflows for reporting, auditing, inventory management, financial dashboards, and more.

📁 Files & Examples Included in This Tutorial

Example JSON schema

Power BI table structure

Power Automate Flow mapping

Sample SharePoint list layout

(If you'd like the downloadable package, drop a comment!)

🛠 Tools Used

Microsoft Power BI

Power Automate (Cloud Flows)

SharePoint Online

JSON formatting + schema generation

🎙️ New to streaming or looking to level up? Check out StreamYard and get $10 discount! 😍 https://streamyard.com/pal/d/67538971...