Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Forms to power bi

Hello,

 

I'm trying to create a flow, that takes data from Microsoft Forms and update it on a Real Time Data at Power BI, using the power Automate. I was able to generate the flow, but when I try to see the results at Power BI it only shows me the columns. The answers of the forms would be the rows of the Table. Can you help me discorver why the rows are not appering?

 

The flux is: 

 

Answer at Forms (Trigger) -> Get the forms's data -> RealDataBase At Power BI 

 

Best Regards

Raul Luis Laurindo

Intern at JDE - Brazil 

 

Need Help
Tips and Tricks
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    6 years ago

    yes, I use a Pro license (and we are on Premium capacity but that may not be relevant).  Sorry, should have mentioned that.

10 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    Is that a hybrid streaming dataset you push the rows into?  Is "data"  your UTC datetime stamp field?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes It is a hybrid streaming. And the "Data" field is the UTC Time, one of the answer for the forms's questions. 

       

      The information about the questions are appearing in the columns, but the answers that should appear at the rows are not.  

      • lbendlin's avatar
        lbendlin
        Super User
        6 years ago

        I didn't understand that last part.  Are you saying that instead of the question responses you get the question titles back?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-xuding-msft 

       

      I tried to refresh, it doesn't works. I did exactly like the video you sent. 

      I tried to create 3 different forms and it doesn't work too. The columns with the forms questions appears at power bi, but the rows that should show the answers doesn't. 

       

      Thanks for the answer, I hope you can help me!