How can I use dynamic data from excel sheet as data source for creating Power BI reports.

[Anonymous]

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!

[v-yiruan-msft]

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