Power BI Report with Microsoft Form response data as a Data source

[amsrivas]

Hi,

Scenario

1. Microsoft Form 

2. Power BI Report where source is data of User Response via Microsoft Form.

Requirement : 

Way to create Power BI report which uses data (user response from Microsoft form) as a source (I dont want to oerform any manual activity to acheive data )

Thanks

Amit

Thanks Amit Srivastava

[cathoms]

Here is another approach that might work:

Using Microsoft Forms with Power BI - School Analytics Ltd

[amitchandak]

@amsrivas , refer if these can help

https://www.youtube.com/watch?v=0T6eY0U1M4Y

https://powerusers.microsoft.com/t5/Building-Flows/Microsoft-Forms-Flow-Power-BI/td-p/575979

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/From-Forms-to-PowerBI-and-the-glue...

https://community.powerbi.com/t5/Desktop/Power-Bi-amp-MS-Forms/td-p/164042

[amsrivas]

Hi @amitchandak 

Thanks for the all useful link.

All the provided ones are based on Streaming data however what i required is to have Excel sheet of user responses from the form so that i can place it to the sharepoint Folder.

Is there any way to simply place the data file at Sharepoint folder.

Thanks

Amit

[v-deddai1-msft]

Hi @amsrivas ,

You need to use your SharePoint List prepped to catch the data that your Microsoft Flow will sync to your List from your Microsoft Form. Then use connect to sharepoint list via power bi desktop. For more details, please refer to  https://www.knowledgewave.com/blog/connect-a-form-to-a-sharepoint-list-using-microsoft-flow

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai