Forum Discussion
Solved
Real Time Dashboard refresh, whenever data is changed.
Hello everyone, I am looking for an idea on how to implement this project using Power BI. I have several Excel files, which should ideally be stored on a SharePoint so that different users can acces...
Hello timbckr812
To achieve more frequent updates, you can use Power Automate in combination with Power BI:
1. Create a Power Automate flow triggered by file changes in SharePoint.
2. Configure the flow to refresh the Power BI dataset when the Excel file is modified.
3. This approach can provide near real-time updates, typically within a few minutes of data changesPlease Store your Excel files on SharePoint to allow simultaneous editing by multiple users
Connect Power BI Desktop to these SharePoint-hosted Excel files as the data sourcePlease check if this is helpful
timbckr812 could you please accept the solution , as it will help the community to find the right answer quickly.