Semantic model schedule refresh is taking so long

Hi Ynr225 ,

Thank you for your inputs, bhanu_gautam . In support of bhanu_gautam  response, I would like to add a few points for further clarification.

1. This mode enables tables to function as both Import and DirectQuery, enhancing performance but also increasing refresh management complexity. Ensure your dataset is optimized according to your reporting requirements.
Use storage mode in Power BI Desktop - Power BI | Microsoft Learn

2. If the report is not publishing, check for ongoing refresh processes in Power BI Service that might be causing conflicts. Try disabling the scheduled refresh, publishing the report again, and then re-enabling the refresh once the issue is resolved.
Configure scheduled refresh - Power BI | Microsoft Learn

3. Refresh times in Power BI Desktop vs. Power BI Service can vary due to network latency, resource constraints, and query execution methods. If your Oracle queries are fast in Desktop but slow in the Service, consider.

Optimizing Oracle database indexing and execution plans.

Minimizing Power Query transformations to reduce processing overhead.

Data refresh in Power BI - Power BI | Microsoft Learn

4. Review the refresh history in Power BI Service to identify errors and performance bottlenecks. If your queries involve transformations, ensure query folding is enabled so that transformations are processed directly in Oracle instead of Power BI.

I hope this helps...