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 

     

Idrissshatila's avatar
Idrissshatila
Super User
1 year ago

Hello timbckr812 ,

 

nilendraFabric 's approach is the best approach in your situation,

 

I would just leave a note on what you said regarding the refreshes, they are 48 in a premuim license, but with a pro license they are only 8.

 

so just take this into consideration before you take the decision.