Power BI Meets Forms | A Fully Automated Method Using Power Automate And SharePoint

[@BILingualAnalytics]

Have you ever branched out to Power Automate as a Power BI developer? If so, what made you do that? Let me know here 👇👇👇

[@kufreudom6764]

Very Helpful. Thank you

[@BILingualAnalytics]

Happy to hear you liked it!

[@karinahulka1486]

amazing and refreshing video)

[@BILingualAnalytics]

Thanks for the kind words!

[@natalialopez1697]

hello, great video, could you please share the query you paste when adding the Blank query, thank you!!

[@ravbuddy]

Hi, thank you for the video. Could you achieve a similar result by just having one excel file as your power bi source data, and use power automate action of Add a Row in excel? Would you still be able to set up automatic data refresh in the power bi report?

[@BILingualAnalytics]

Yes, in theory it’s also a way to get the same/similar result.

[@haihuynhthanh3078]

Hello Roland Can you answer a question for me? I've uploaded a file with the Image type to an MS Form using an image I selected from my OneDrive. How is the Value column used in the "Create csv table" Action when the Header is an image?

[@BILingualAnalytics]

That's a great question. But I guess your answers are not going to be images, right? So survey responders are going to answer a question based on the image. So it should cause trouble

[@haihuynhthanh3078]

Hello Roland, thank you very much, i am very prefer all your video. can i ask a question? In MS Form: have field "Rate", but in Action "Create csv table", i forgot input field "Rate". Then, i test some survey okay --> run in Direct PQ, BPI Desktop okay (with 4 columns). After i remember that i miss field "Rate", i add Header & Value for field "Rate" in Action "create csv table" okay --> make a new survey with 5 column. How to Direct PQ update dynamic with 5 columns (some prev responses: blank for 5th column "Rate"? Thanks. i miss some skill in Power query.

[@BILingualAnalytics]

Hey, thanks for the kind words! So yeah, I missed a field while adding those columns in the "create csv table" step :) This is why I suggested testing the full automation before going live. What I have done is deleted all files from SharePoint and then re-run the test with previous triggers. That essentially moved the dummy files with the right fields back to SharePoint.

[@chucknorris777]

how to agregate survey respons into one file ? the number of files created could be little too big

[@BILingualAnalytics]

The number of files doesn’t really matter as PQ can combine all of them into a single master table. As long as you keep all responses in one location

[@moneytrends5231]

I have a form used for inspections which is very complicated with branched options, GPS data, pictures, etc. I currently use Access with its queries and reporting. We're moving towards power automate and want a more robust survey form. Do you think microsoft forms is robust enough for gathering ~100 data points?

[@BILingualAnalytics]

It can definitely handle large number of questions. I’m not 100% sure what do you mean by branched option. Are they type/subtype kind of questions? I would also look into Power Apps as you can develop much more robust applications in it. And Power Apps definitely has “conditional” options.

[@moneytrends5231]

@@BILingualAnalytics thank you for the suggestion. I will look into it

[@karinahulka1486]

power automate is not free, even as an extension in power bi?

[@BILingualAnalytics]

Unfortunately, no :(