Transfer Power Bi Data Into Sharepoint Using Power Automate
 

What you'll learn
You will Learn How to Export data from a Power BI Table into in Excel Spreadsheet
You will Learn How to Export data from a Power BI Table into a SharePoint List
You will Learn How to Filter Data from a Power BI Table into a SharePoint List
You will Learn How to Create a Deep Link to a Specific page in a Power App
You Learn How to Connect a SharePoint List to a Power App
Requirements
Experience using Power BI Reports
Description
Welcome to this course where you'll learn how to connect Power BI, Power Automate, and SharePoint into a seamless data-driven workflow.In this course, we'll show you how to transfer data directly from a Power BI report into a SharePoint list using Power Automate and JSON. You'll trigger this automation by pressing a button inside Power BI, instantly capturing selected data from your report and sending it into SharePoint in real-time.You'll also learn how to filter specific data from a table in a Power BI report. When the user selects an item in the Power BI table, the specific data will directly to the SharePoint List preloaded with the exact data they submitted from Power BI.But we're not stopping there.You'll also learn how to connec the SharePoint List to a Power App. When the user selects an item in the Power BI table, they'll jump directly to a specific screen inside Power Apps-preloaded with the exact data they submitted from Power BI.By the end of this course, you'll know how to build a complete business workflow using Microsoft's Power Platform-perfect for approvals, audits, or any process where you need to capture, store, and review report data dynamically.We will walk you step by step so that you have a clear understanding of what is happening.So if this excites you and if you are ready to learn how to automate and streamline your manual and redundant business processes and become a rockstar at your organization, Let's get the automation started!
Overview
Section 1: Introduction and Course Requirements
Lecture 1 Introduction
Lecture 2 The Applications that you will need for this course
Section 2: The Use Case and Customer Requirements
Lecture 3 The Use Case and Customer Requirements
Section 3: Create a SharePoint List from Excel
Lecture 4 How to Get the Data in this Course?
Lecture 5 How to Transfer Excel Columns into a SharePoint List
Section 4: Import the Excel Data into Power BI and Publish the Report
Lecture 6 Import the Excel Data into Power BI
Lecture 7 Change the Columns in the SharePoint List
Lecture 8 Save the Power BI file and Publish to a Workspace
Section 5: Export Power BI data into Excel
Lecture 9 Create a Power Automate Flow to Export Power BI Data into Excel
Section 6: Transfer the Power BI data into the SharePoint List
Lecture 10 Create a Power Automate Flow to Export Power BI Data into a SharePoint List
Lecture 11 Adjusting the Power Automate Flow
Lecture 12 Delete SharePoint Records
Section 7: Create the Power Automate Flow to Filter Power BI data and send to SharePoint
Lecture 13 Create Slicer and Measure in Power BI
Lecture 14 Create a Flow to Filter the Power BI Data and Send to the SharePoint List
Lecture 15 New Customer Requirements
Lecture 16 Create a Measure for a Selected Part Number and a Measure for Instructions
Lecture 17 Create a Measure that Identifies the Name of the Selection
Lecture 18 Change the Flow to Filter Power BI Data by Part Number or by Inventory Manager
Section 8: Create a Power App
Lecture 19 Customer Requirements
Lecture 20 Create a Power App
Lecture 21 Make Modifications to the Form in the Power App
Lecture 22 Create a Deep Link to the Power App
Section 9: Course Files
Lecture 23 Inventory Data
Intermediate Power BI users,Beginning to Intermediate Power Automate users