Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
5 years ago
Solved

Gateway Timeout Error

Hi - I keep getting this message when trying to refresh my model for the first time. Any idea what it can be? It keeps timing out after 2 or 3 hours. I checked advanced setting for SQL and those time...
Need Help
Tips and Tricks
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, PowerBI123456 

    What’s your workspace’s capacity? Do you use Premium workspace? Here’s the refresh time limitation for a scheduled refresh in Power BI service:

    Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.

    As we can see, you scheduled refresh for imported datasets timeout after two hours if you aren’t in the premium workspace. Therefore, I suggest you to upgrade your workspace to Premium workspace if you have started the PPU trail, like this:

     

    More info about scheduled refresh timeout

    Power BI Premium Per User FAQ

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Super User
5 years ago

PowerBI123456 When you mentioned advanced settings, I guess you mean checking advanced setting in Power BI when you made the connection to SQL Server, correct?

 

  • PowerBI123456's avatar
    PowerBI123456
    Post Partisan
    5 years ago

    Yup, those are set at 5 hours and my model is timing out at 2 or 3 hours