Issues with Report Refresh – Semantic Model Stuck (2nd Mail)

[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:

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:

[v-anbandari]

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.

[123abc]

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 

[andrewsommer]

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.  

[Natarajan_M]

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!

[123abc]

I dont have Premium User License now waht i can do ? could you guide me how to solve the issue without it ?

[v-anbandari]

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:

1. Open Power Query (Transform Data) and identify which table/query is taking the most time
2. Optimize it by removing unnecessary columns/rows and avoiding heavy joins
3. Apply filters early and move transformations to the source if possible
4. Reduce the overall dataset size (avoid loading full historical data)
5. 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.
   

[123abc]

Thank you very mcuh v-anbandari,  i will try this and will inform you. Thanks again.

 

 

[v-anbandari]

Hi @123abc ,

Just checking in again on your issue. Could you please confirm if the solution worked?

Please let us know if you need any further assistance.

Thank you.

[123abc · Accepted solution]

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.

[v-anbandari]

Hi @123abc,

Thank you for the update. I completely understand your concern.

Please try the optimization steps shared earlier and monitor which query is consuming the most refresh time. That should help narrow down the root cause and reduce the manual effort involved.

I hope this helps. Please feel free to reach out if you have any further queries.