FASTEST Method for Reporting on SURVEY Data in Power BI

This technique unpivots Microsoft Forms data in Power Query to combine responses into a single column in Power BI. This lets us calculate percent of total and counts of responses by question without having to create a measure and visual for every question.

We connect to the Microsoft Forms data in SharePoint in this example, which we can schedule refresh on, but it will work survey data from other sources as well.

Here’s some relevant follow-up videos!
You could apply row-level security with your organizational hierarchy to show managers data for people who report to them with this technique:
   • Dynamic Row-Level Security in Power BI  

Schedule refresh on SharePoint file sources (which MS Forms is!):
   • How to Schedule REFRESH on File & Fol...  


0:00 Intro/demo
1:48 Connect to the data
4:16 Shape and clean the data
7:38 Create the measures
9:50 Configure the visual
12:50 Create a score “out of” a number
14:30 Other ideas