Forum Discussion
Power BI Refresh?
Hi All,
I’m wondering if it’s possible for someone else to refresh a Power BI dashboard in my absence.
Will this scenario work:
- The Excel files are dropped into a OneDrive folder.
- The Power BI Service has automatic refresh set up (please see the image below).
Will the dashboard refresh automatically in this case?
Or does the Power BI report still needs to be manually refreshed from the desktop?
Thank you for your help in advance.
Hello Anonymous,
Thank you for reaching out to the Microsoft Fabric Forum Community. Based on your scenario and the screenshots you've provided:Yes, your Power BI dashboard will refresh automatically if the following conditions are met:
- Your Excel files are stored in OneDrive.
- You've configured a scheduled refresh in Power BI Service (as shown in your screenshot) to run daily at 10:30 AM and the report is already published to Power BI Service and uses the OneDrive for Business connector or Web connector with authentication.
Power BI Service is capable of refreshing data from OneDrive-hosted Excel files without manual intervention, provided the file path hasn't changed and there are no gateway requirements. if your setup meets the above. The scheduled refresh in the Power BI Service will handle it.
For best practice always ensure that the dataset credentials are up to date and confirm the file is saved to OneDrive for Business, not just local OneDrive on your machine.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
3 Replies
Hello Anonymous,
Thank you for reaching out to the Microsoft Fabric Forum Community. Based on your scenario and the screenshots you've provided:Yes, your Power BI dashboard will refresh automatically if the following conditions are met:
- Your Excel files are stored in OneDrive.
- You've configured a scheduled refresh in Power BI Service (as shown in your screenshot) to run daily at 10:30 AM and the report is already published to Power BI Service and uses the OneDrive for Business connector or Web connector with authentication.
Power BI Service is capable of refreshing data from OneDrive-hosted Excel files without manual intervention, provided the file path hasn't changed and there are no gateway requirements. if your setup meets the above. The scheduled refresh in the Power BI Service will handle it.
For best practice always ensure that the dataset credentials are up to date and confirm the file is saved to OneDrive for Business, not just local OneDrive on your machine.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.Hello Anonymous,
Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.
Please don’t forget to “Accept as Solution” and Give “Kudos” if the response was helpful.
Thank you.Hello Anonymous,
Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.Thank you.