Forum Discussion

BrandonP2121's avatar
BrandonP2121
Icon for Helper II rankHelper II
6 years ago
Solved

Power BI pulling multiple versions of same answer from Forms

Hello,   I will explain this as best I can. I created a Form and have that data pulling into Power BI. Question 1 on my Form is a regular single answer multiple choice question, and Question 2 is a...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    Yes. It would involve splitting and parsing data in Power Query, but to assist, I'd need to see some real data to ensure I am understanding correctly and can post back a solution. A "good" row and a "bad" row with this duplication would be helpful so I can know what you want vs what you are currently getting.

     

    And what is the data source? You said form... is this Microsoft Forms using Excel, or something else?

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

Yes. It would involve splitting and parsing data in Power Query, but to assist, I'd need to see some real data to ensure I am understanding correctly and can post back a solution. A "good" row and a "bad" row with this duplication would be helpful so I can know what you want vs what you are currently getting.

 

And what is the data source? You said form... is this Microsoft Forms using Excel, or something else?