Connecting Microsoft forms to powerbi

[StevenT]

Hi, I'm a home user with microsoft 365 and powerbi pro license.
I want to learn how to connect forms and powerbi together.  But I don't have sharepoint.

How would you suggest i connect forms to powerbi if I don't have Sharepoint to use?  Is there a way i can do something similar if I had sharepoint on my desktop?

[Expiscornovus · Accepted solution]

Hi @StevenT,

What is your aim of the connection? Do you want to present the results/answers in Power BI?

You could for example create a Power Automate flow which triggers when a new response is submitted and store this in a data source (this could for example be an Excel file on your OneDrive) via that flow. After that you could use that data source in your Power BI report. 

[StevenT]

I like this idea. Thanks and I'll try it!

[v-xiaocliu-msft · Accepted solution]

Hi @StevenT ,

As @Expiscornovus  said, please consider creating an excel in onedrive, creating a flow get the submitted form data and saving the data to the excel in onedrive. Then you can get the excel data from power bi.

//Create an excel file and create a table with column name.

// Please note that using flow requires a power automate license

Best Regards,

Wearsky

[Expiscornovus · Accepted solution]

Hi @StevenT,

What is your aim of the connection? Do you want to present the results/answers in Power BI?

You could for example create a Power Automate flow which triggers when a new response is submitted and store this in a data source (this could for example be an Excel file on your OneDrive) via that flow. After that you could use that data source in your Power BI report.