Power Bi Scheduled Refresh Time Out

[Anonymous]

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 Pro license and scheduled daily refresh has been implemented as new files will be added to the SharePoint on a daily basis. 

Recently in my refresh, i notice that my dashboard has been experiecing Time Out issues when it refreshes for more than 120 minutes. Are there any ways to increase the time out duration to 180 minutues instead?

Much help will be needed.

Thank you

[v-janeyg-msft]

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]

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 · Accepted solution]

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.

[lbendlin]

Do you know which part of your process causes the long duration?  In Power Query you can do query performance diagnostics to see which part takes the longest.

How big are your Excel files?

[Anonymous]

Yes, i think i know which part of the process causing the long duration, it will be due to pivot and unpivot of data to do some calculation. 

I have about 1 file of 80 MB which uses the process above and about 20 files of 60MB which is just direct read of from SharePoint