Power BI Meets Forms | A Fully Automated Method Using Power Automate And SharePoint
5 هزار بار بازدید -
پارسال
-
In today's tutorial, I'd like
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 Automate - How to au...
How To Group Field Parameters in Power BI Using DAX - Enhance Report UI - How To Group Field Parameters in Powe...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - Dynamic Row-level Security 🔐 - Based ...
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 - LinkedIn: bilingualanalytics
Twitter - Twitter: BILAnalytics
Subscribe - @bilingualanalytics
ABOUT ME: https://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
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 Automate - How to au...
How To Group Field Parameters in Power BI Using DAX - Enhance Report UI - How To Group Field Parameters in Powe...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - Dynamic Row-level Security 🔐 - Based ...
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 - LinkedIn: bilingualanalytics
Twitter - Twitter: BILAnalytics
Subscribe - @bilingualanalytics
ABOUT ME: https://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
پارسال
در تاریخ 1402/03/10 منتشر شده
است.
5,072
بـار بازدید شده