Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Load data from Microsoft Forms, Rating type question

Hi.   I created a form with dummy data to test how i can visualize the various question types in Microsoft Forms.   The Question type "Ratings" has this great build-in visual: When I impor...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks amitchandak .

 

Did try that, but then the data looks like this:

I'm fairly new to Power BI, so my apoligies if this seems simple to you, but I could not find a standard visual that generates the same look as the one in Forms.

 

As parry2k noted I can achieve it by splitting into seperate rows, I was just wondering if there was a method in which I could get the same result without splitting the data

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous 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?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

     

     

     

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      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.⚡