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