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

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

amazing and refreshing video)

@BILingualAnalytics

Жыл бұрын

Thanks for the kind words!

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

4 ай бұрын

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

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

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.

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

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

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

@BILingualAnalytics

Жыл бұрын

Unfortunately, no :(