Issues with Report Refresh – Semantic Model Stuck

[123abc]

Dear Fabric Community,

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:

1. Deleted the semantic model and republished it.
2. Created a new workspace and published the reports there.
3. 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:

[v-nmadadi-msft]

Hi @123abc ,

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.

[123abc]

Hi Sir,

Thank you very much for your kind support and continuous follow-up regarding this matter.

Unfortunately, the issue is still persisting. At the moment, our IT department and Oracle Server Administration team are occupied with ongoing server maintenance and system upgrade activities. They are expected to be available by coming Monday, after which they will review and investigate the matter further with me.

I will keep you updated on Monday regarding the status and whether the issue has been resolved.

Thank you once again for your patience, cooperation, and valuable support. I truly appreciate your assistance throughout this process.

[v-nmadadi-msft]

Hi @123abc ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

Regards

[Wikkleyn_81]

@123abc Have you checked with the Oracle DBA if that query runs on teh database and why it doesn't finish? 

[123abc]

No, Let my check.... but report is properly refreshed on desktop in 2 min 30 sec  but not on BI service...🥺 

[v-sshirivolu]

Hi @123abc ,

It is possible that the refresh is failing due to a scheduled refresh timeout in the Power BI Service, particularly if the dataset refresh is taking longer than the allowed processing window or encountering resource constraints during execution.

Please try:
Reducing the model complexity. Simplifying the model, especially if it involves computationally expensive calculated tables and columns, can help to lower the refresh burden and avoid memory bottlenecks during refresh. If possible, move calculated tables and columns to the data source or ETL processes.

Use incremental refresh for large semantic models. By automatically partitioning large tables, incremental refresh can help to reduce the amount of data that needs to be refreshed. By refreshing only the most recent import partitions, you can significantly reduce the refresh duration, thus making room for more refreshes in a given timespan.

[v-sshirivolu]

Hi @123abc ,

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

[123abc]

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 people are using my Sales and Planning Power BI dashboards, 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.

[v-nmadadi-msft]

Hi @123abc ,
If you believe the issue is critical to day to day work. Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious. 

Below is the link to create Microsoft Support ticket:

Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

Regards

[123abc]

Thanks, i am on the way to troubleshoot the issue, i will update you after review the solution.

[tayloramy]

Hi @123abc, 

Can you show a screenshot of the refresh history of these models? Hover over them, click the 3 dots beside the name, and click refresh history. 
 

[123abc]

First of all Thank You So mcuh for your quick and prompt response. Thank You Agiain:

Following Error is now showing:

Refresh History is as below:

The detail is as per below:

Further detail is as per below:

[GilbertQ]

Hi @123abc 

With the error that you are showing, it could well be that the data source that you are trying to query could have an issue. What I would recommend doing is going on to your Power BI gateway and making sure that you can connect from the gateway to your data source as well as the gateway can connect to the Power BI service.

[123abc]

My gateways is proper connected as per below connectins detail: