FASTEST Method for Reporting on SURVEY Data in Power BI
This video demonstrates the fastest method for reporting on survey data in Power BI. It shows how to unpivot Microsoft Forms data in Power Query to combine responses into a single column, allowing for calculations of percentages and response counts without creating measures and visuals for each question. The example connects to Microsoft Forms data in SharePoint, but the technique can be applied to survey data from other sources as well. The video also provides additional resources on applying row-level security and scheduling refresh on SharePoint file sources. The video covers connecting to the data, shaping and cleaning it, creating measures, configuring the visual, creating a score, and offers other ideas.
Video 12m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time