In today's tutorial, I'd like to share a project involving Microsoft Forms, Power Automate, SharePoint, and of course Power BI.
I was tasked to deliver an end-to-end automation based on a survey that our team has created to survey potential customers using Microsoft Form. However, getting responses out of Form is not that straightforward - at least not in an automated fashion.
It meant that I had to utilize Power Automate to export each response to a SharePoint site.
Once those responses were made available there, picking them up with a Power BI Dataflow and creating a report was a walk in the park...
I hope you like this solution!
Have a good one,
Roland
💪 New videos coming every Tuesday 🤹♂
🤘 New short videos coming every week 👨🏫
🎬 MORE VIDEOS:
Power BI & Power Automate - How to automate reporting process -
• Power BI & Power Autom...
How To Group Field Parameters in Power BI Using DAX - Enhance Report UI - • How To Group Field Par...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Secu...
Chapters:
00:00 Topic Of The Day - Automated Forms Reporting
00:46 Intro
00:56 BI-Lingual Analytics
01:15 What To Expect - The Project
02:01 Tools Used - Features
02:32 Microsoft Forms - Survey
03:55 Power Automate - Export Data
06:30 Power Automate - Templates
07:22 Test No1
08:08 Power BI - DataFlow and Report Creation
08:48 Power Automate - DataFlow and Data Refresh
10:08 Test No2 - Go Live
10:48 Summary
11:46 Questions? Comments?
11:58 End
▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - / bilingualanalytics
Twitter - / bilanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: bilingualanalytics.com.au/abo...
📍 - Sydney, Australia
📽 GEAR:
📷 - Sony ZV-E10
🎙 - Audio Technica AT2020
🔦 - Neewer 18” Ring Light, Elgato Key Light
🎧 - BOSE QC35
🖥 - ASUS VC279H + Xiaomi Mi Curved 34"
💻 - Intel i7-12700K, Gigabyte Aorus Master 3080 12GB, Corsair Vengeance LPX 64GB, Samsung 980Pro 1TB
Music: www.bensound.com
#PowerBI #PowerAutomate #BILingualAnalytics
Негізгі бет Ғылым және технология Power BI Meets Forms | A Fully Automated Method Using Power Automate And SharePoint
Пікірлер: 17