Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Forms--> Excel(One Drive)--> Power BI
Currently I am planning to use forms to collect monthly data and then using Power Automate to get data in excel(one drive) which can be further used as dataset for Power BI reports. But my concern is how can Power BI identify the data if I make some changes in the forms, which would again require setting up Power Automate. Can I automate the process where change in forms would reflect in the excel(one drive) automatically?
Thanks!
Hi @Anonymous ,
Please check if the below video is what you are looking for:
How to sync Microsoft Excel with Microsoft Forms responses (using Power Automate)
Best Regards
Rena
User | Count |
---|---|
65 | |
27 | |
25 | |
17 | |
11 |