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!
@natalialopez16972 ай бұрын
hello, great video, could you please share the query you paste when adding the Blank query, thank you!!
@ravbuddy6 ай бұрын
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?
@BILingualAnalytics6 ай бұрын
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?