Forum Discussion
Using Microsoft Form Data
I was wondering if I could get a clever solution from you guys. I have data being collected from a Microsoft form. I was wondering if you guys had a more elegant way of capturing the data as i...
Thank you, Anonymous. It's quite clear now.
We can split the [Value] in the Query Editor. Then we can create a Matrix easily. Please check out the demo in the attachment.
Best Regards,
Dale
Hi,
I find difficulties in reaching a Forms source I did not created.You seems OK with source : for me Forms https URL is not aknoloedge as a web source apparently : how did you got your Forms source from PBI Desktop ?
thx in advance
Since you did not create the source it will be difficult to import.
https://davidlozzi.com/2018/02/06/use-microsoft-forms-to-collect-data-right-into-your-excel-file/
I used this guide previously to create a form with an excel file. I would then import that file into power bi.