Time Out while refresh power bi report in the service

[ahmedshalabyy12]

Dears, 

what's the reason for this error 

thank you 

[ahmedshalabyy12 · Accepted solution]

Solution to make the dataset less than 1gb  while publishing from desktop to the service 

[BhavinVyas3003]

The dataset or query took too long to load, Try to apply following steps,

• Optimize queries and remove unused columns/tables.
• Use Incremental Refresh for large tables.
• Ensure Query Folding is enabled.
• Increase timeout if using on-prem gateway.
• Move to Premium/Fabric Capacity for better performance.

[ahmedshalabyy12]

Thanks for your support the solution to make the dataset less than 1gb it worked 🙂 

[lbendlin]

Semantic models have a hard refresh limit of 5 hours (18000 seconds). Your refresh took too long.