Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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!

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors