Forum Discussion

amokrane's avatar
amokrane
Frequent Visitor
5 years ago
Solved

Timeout value in powerbi service

Hello,   I have a dataset for 3 days I can not update it on Power BI service, knowing that on DESKTOP it is normally updated in 30 minutes. the dataset is powered from a SQL server database, via a ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi amokrane ,

     

    How long is it running before timing out?

    One thing you could try is setting the Time out parameter on the connection. Try setting this to something larger than 3600, like 7200 for 2 hours or even 36000 for 10 hours.

     

    Default number if you put nothing = 10min

     

    Based on your description, I think the above error could be caused by that the data model size in your PBIX file is too large. As stated in this blog, refreshing the dataset will give an error message indicating you that your dataset is too large when data model size grows beyond 1 GB.
    If the data model size is too large, please break up your dataset into smaller datasets and refresh them in Power BI Service.

     

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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