Forum Discussion

JeanBaptiste's avatar
JeanBaptiste
New Member
2 years ago
Solved

Power BI

Hello dear experts. I made a Form Microsoft form that employees fill out every day. Then this generates an updated Microsoft Excel file each time the form is submitted. I created a Power BI applicati...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JeanBaptiste 

     

    Maybe you can try the following step:

     

    Save Your Excel File on OneDrive for Business or SharePoint Online: To enable automatic updates in Power BI, your Excel file needs to be stored in a cloud service like OneDrive for Business or SharePoint Online. This setup allows Power BI to check for updates in the Excel file approximately every hour. If changes are detected, Power BI automatically updates your reports and dashboards. For more details on this process, please refer to the documentation: Refresh a semantic model created from an Excel workbook - cloud - Power BI | Microsoft Learn

     

     

     

     

    Best Regards,

    Jayleny

     

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

christinepayton's avatar
christinepayton
Most Valuable Professional
2 years ago

Microsoft Forms creates a single Excel file that gets updated when responses come in - just want to make sure that's what you're experiencing since it sounds from the description like it's creating a new file each time? You can connect to the Excel file in SharePoint with Power BI and schedule refresh on the semantic model. That will let it update each time the scheduled refresh runs. 

 

I did a tutorial here on exactly this here, if it helps! https://youtu.be/omL20HXxXXc