Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Bi Scheduled Refresh Time Out

Hi guys, I am new to Power Bi and require some help on it. I have created a new Power Bi file where it is reading excel files from SharePoint. The dashboard has been published to web using my PowerBi...
power bi schedule error refresh not working
PowerBI Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    You can reduce the file size from the following ideas:

    Optimize the data model,relationship,dax formula.

    Reduce the data source data, clean unused data regularly.

    Only import the columns you need.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

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

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Anonymous 

 

It’s my pleasure to answer for you.

According to your description, You can refresh successfully before, but you have refresh timeout problems recently, right?Is your file size increasing every day? You can try to control the file size to avoid refresh timeout, if not, you may need to upgrade to a premium licence.

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Janey,

 

Thank you for the reply. 

 

Yes, you are right. Only recently the timeout issue occur as the file size will increase daily. How would you recommend for me to control the file size?

 

The premium license is too pricey for me at this stage. Will there be an alternative solution to it?

 

Regards,

Jacky

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    You can reduce the file size from the following ideas:

    Optimize the data model,relationship,dax formula.

    Reduce the data source data, clean unused data regularly.

    Only import the columns you need.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

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