Forum Discussion
Load data from Microsoft Forms, Rating type question
Well I'm experimenting with publishing the data "near real time" so whenever I get a new Forms answer, the visualization gets updated. For this I have found some helpful guides on how to do that using Power Automate, but as I'm new to this area, I'm trying to avoid too complex scenarios.
I think I can manage if all the survey responses are in, but I'm trying to create a visualisation that works as each Forms response get's in.
I'm sure it can be done even automating the steps in Power Query, I'm just not on that level yet when it comes to handling new data that gets updated after I modeled the original data.
I will split the data and read up upon how to handle new data after the modelling.
I guess it's only a question of time before Microsoft enables a native forms integration into Power BI (It may alrady be there, but I have not found it), but until then I'm fiddling with both Power Automate and Power BI to get the needed results.
Thanks again, much appreciated
Anonymous thanks for explaining. There are two separate parts, how the data reaches to the dataset and model/transformation. Once you have done transformation and all your visuals, after that it doesn't matter how data get refreshed, thru power automate, someone manually does it, transformation step is going to run and update the visuals.
Good luck!
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡