Forum Discussion
Load data from Microsoft Forms, Rating type question
Super UserAnonymous spitting is your friend, end of the day everything is based on the good data model and splitting into rows is a good model. Question is why you don't want to split? What is the reservation? Why do you want to work from a single column? What business goal you are trying to achieve keeping the values in one column?
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