Forum Discussion

timbckr812's avatar
timbckr812
Regular Visitor
1 year ago
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...
Need Help
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    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 changes

     

    Please 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 source

     

    Please check if this is helpful 

     

nilendraFabric's avatar
nilendraFabric
Super User
1 year ago

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 changes

 

Please 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 source

 

Please check if this is helpful