Forum Discussion
PowerBI Dahsboard Refresh Stuck on "Started Data Refresh" When Using Scheduled Refresh.
Hi Everyone,
At our company we have PowerBI dashboards uploaded to a report server that have scheduled refresh schedules (Like once a day at 5:00 AM). The problem I am facing is that a new dashboard that's been created is not auto refreshing like expected. What seems to happen is the refresh will start at the correct time and the status column will indicate "Started Data Refresh" but it will never move beyond that and will never say "Completed Data Refresh" like the other dashboards. I can also confirm that the dashboard is not updated. However, when I manually go to initiate a refresh, everything will work as expected and afterwards it will say "Completed Data Refresh"
To add more context, this dashboard is using a lot of data located in a sharepoint folder. The size of all the data is ~1.6 GB. Is the answer here that there is too much data and its stuggling to update the dashboard?
Is there anything I can do apart from lowering the amount of data to ensure that there is no problem with the automated refresh?
Thanks everyone.
Hi Nate12345,
You're welcome! Glad to hear you're trying out data filtering.You can adjust the Report Execution Timeout in Reporting Services by modifying the settings in Manage > Properties within the Web Portal, under the Advanced > Report time-out section.
For your reference: Set time-out values for report and shared dataset processing in Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn
If you find this information useful, please “Accept it as a solution” and give it a 'Kudos' to assist others in locating it easily.
Thank you.
6 Replies
Hi Nate12345,
Thank you for reaching out to the Microsoft Fabric Forum Community.
After thoroughly reviewing the details you provided, consider the following troubleshooting steps:- Check your data source credentials are stored correctly.
- Since your dataset is approximately 1.6 GB, it might be hitting performance limits. Try filtering unnecessary data before loading it into Power BI, optimizing queries in Power Query and testing with a smaller dataset to see if the refresh completes successfully.
- If your refresh takes too long, it may get stuck. Increase the timeout settings and restart the service.
- Make sure you are using the latest version of Power BI Report Server, as older versions may have bugs affecting scheduled refreshes.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.Hi v-ssriganesh,
Thank you for your detailed response! I'll try filtering unnecessary data. But you mentionned increasing the timeout settings and restart the service. I'm not sure what you mean by that. How do I do that?
Thank you again for your help!
Hi Nate12345,
You're welcome! Glad to hear you're trying out data filtering.You can adjust the Report Execution Timeout in Reporting Services by modifying the settings in Manage > Properties within the Web Portal, under the Advanced > Report time-out section.
For your reference: Set time-out values for report and shared dataset processing in Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn
If you find this information useful, please “Accept it as a solution” and give it a 'Kudos' to assist others in locating it easily.
Thank you.Hi Nate12345,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.
Hi Nate12345,
May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi Nate12345,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
