Forum Discussion

PBISM's avatar
PBISM
New Member
3 years ago
Solved

Dashboard auto refresh not working

Hi All,   I am trying to test an auto PBI dashboard refresh. I have a simple dashboard that is connected to an Excel file hosted on One Drive For Business. The Excel file has only 1 table with some...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PBISM ,

    There are two ways for you, please refer:

    1. You could try OneDrive Refresh, it automatically refreshes the dataset once an hour.

       Please refer this document: Data refresh in Power BI - Power BI | Microsoft Learn

     

    2. You could create a flow in Power Automate, you need put your data to SharePoint, then create below flow, Power Automate provide the template.

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
3 years ago

Hi PBISM 

You are not doing anything wrong and all the set up is good. You just need to give it couple minutes for the cache to refresh or do it manually like you did. By the way it is a report that you are talking about and not a dashboard.

tango's avatar
tango
Frequent Visitor
2 years ago

Thanks aj1973 

 

As you mentioned, I noticed that I needed to keep a lag between updating the Excel file and refreshing the dataset even if it's Excel online and immediate save.

 

If I kept a couple of minutes between updates and then refreshed the manual report online, it would update. with the changes.

 

Is it possible to also update the report automatically without doing a manual online refresh. 

 

Thanks

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Direct Query mode connection could be a good solution for you. You won't need power automate either