Forum Discussion
Issues with Report Refresh – Semantic Model Stuck (2nd Mail)
I am using a Pro license of Power BI and facing an issue where two of my reports are not refreshing. They continue to attempt refreshing the semantic model without success. No error messages are displayed. Interestingly, the reports refresh successfully in Power BI Desktop, but the issue occurs only on the Power BI Service. For the past five days, I have been manually refreshing the reports in Desktop and publishing them to the service daily, but the problem persists.
I have already tried the following steps:
- Deleted the semantic model and republished it.
- Created a new workspace and published the reports there.
- Changed the PBIX file names and republished in both the old and new workspaces.
Despite these attempts, the issue continues. I would greatly appreciate any guidance or suggestions on how to resolve this problem.
Best regards,
Ali Abbas Rajput
My all Connections are also live ... there are no issue in there.
Red highlighted report's semantic models are stuck:
Following Error is now showing after 5 hours long time refreshing:
Refresh History is as below:
Refreshing History detail as per below:
My gateways and connections are properly connected as per below detail:
I have alrady posted this massage in Service segment but not catch properlty attention so i apologize again post this massage:
Hi 123abc ,
The issue may be happening because the refresh is running for a long time in Power BI Service and getting cancelled, even though it works in Desktop.
you can try the following steps to address this issue:- Open Power Query (Transform Data) and identify which table/query is taking the most time
- Optimize it by removing unnecessary columns/rows and avoiding heavy joins
- Apply filters early and move transformations to the source if possible
- Reduce the overall dataset size (avoid loading full historical data)
- If the dataset is large, use incremental refresh to reduce the load
You can also refer to these docs for more details:
https://learn.microsoft.com/power-bi/connect-data/refresh-data
https://learn.microsoft.com/power-bi/connect-data/incremental-refresh-overview
I hope this helps. Please feel free to reach out if you have any further queries.
Thank You.
Thank you very mcuh for your quick response and support.❤️
I’m trying to solve this problem because if I can’t fix it, I’ll need to rebuild the entire solution. More than 100 users are using my Sales and Planning Power BI dashboards and reports, so this issue is critical.
Right now, I wake up early every morning to manually refresh all the dashboards in Power BI Desktop and then publish them again to the Power BI Service. It has become very hectic and time-consuming for me.
hank you very much. I am pleased to inform you that the issue has finally been resolved.
After further investigation, I found that the ERP production table was not refreshing properly. The refresh process was taking approximately 6 to 7 hours and eventually stopping without completing successfully.
Our Data Administrator created a separate production table specifically for BI purposes. After connecting to the new table, the issue was successfully resolved.
I would like to sincerely thank the entire Factic Team for your outstanding support, continuous follow-up, and cooperation throughout this process. Your assistance is highly appreciated.
Hi 123abc ,
Thank you for the update.
Please continue using the Microsoft Fabric Community Forum.
Best Regards,
Anusha Bnadari.
13 Replies
I think it is because you don’t have your SharePoint cloud connections set up on your gateway. See your attached screenshot with the red marks next to the SharePoint connections. I don’t think having those set up as cloud connections work if you have the gateway toggled on.
I've always avoided this by using dataflows. When your semantic model is built 100% off dataflows you don’t need the gateway to refresh at all and your dataflows can all have independent set ups.Hi 123abc ,
Try using SSMS and pick a table and refresh it one by one to identify where its failing
To refresh a table one by one using SSMS, connect to the semantic model through SSMS -> Analysis Services -> XMLA endpoint. Then navigate to the model, select the table, go to partition, and choose Refresh All.
Thanks
If you found this helpful, please consider giving it a kudo and marking it as the accepted solution — it goes a long way in helping others facing the same issue.
For more Power BI tips and discussions, let’s connect on LinkedIn:
https://www.linkedin.com/in/natarajan-manivasagan
Cheers!I dont have Premium User License now waht i can do ? could you guide me how to solve the issue without it ?
Hi 123abc ,
The issue may be happening because the refresh is running for a long time in Power BI Service and getting cancelled, even though it works in Desktop.
you can try the following steps to address this issue:- Open Power Query (Transform Data) and identify which table/query is taking the most time
- Optimize it by removing unnecessary columns/rows and avoiding heavy joins
- Apply filters early and move transformations to the source if possible
- Reduce the overall dataset size (avoid loading full historical data)
- If the dataset is large, use incremental refresh to reduce the load
You can also refer to these docs for more details:
https://learn.microsoft.com/power-bi/connect-data/refresh-data
https://learn.microsoft.com/power-bi/connect-data/incremental-refresh-overview
I hope this helps. Please feel free to reach out if you have any further queries.
Thank You.
Hi 123abc ,
Thank you for posting your query in the Microsoft Fabric Community Forum.
Thanks to Natarajan_M , andrewsommer for sharing valuable insights.Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you.
Still not, my issue is still pendnig, i am refreshing my reports mannually, i have tried mulitply methods and solutions but still not succeeded.
Thank you very much.
Best Regard:
Ali Abbas
