Hi all,
I a newbie in Power Automate.
I have created a desktop flow that opens an excel file located in a Sharepoint folder, run a macro (in the macro script I run SAP Analysis for Office) and save as csvs the tables of SAP Analysis Reports. Then the flow saves the excel file and close it.
I want to schedule it to run on 4 times per day. My questions so far are:
- Do I need a License (and what kind of license do I need)
- I will set the Desktop flow in a Desktop PC that is always on (but it maybe turn into sleep mode). Will the flow run if the PC is on Sleep mode? How can I prevent my PC from turning into Sleep Mode?
- Do I need a Data Gateway? My files are all in Sharepoint and the output CSVs also are being saved in a Sharepoint folder
- If a Data Gateway is needed, where should be installed? Is the same as Power BI Data Gateways? Can I install it in my Desktop PC, the same that I will use for my flow? Then, if is the same with Power BI data Gateway, can I use it for Power BI reports too?
- I have heard in a video that I have to setup a desktop connection? How?
Thank you in advance!
Best Regards,
Eleftheria
