Power Pivot in Excel for One Drive Error "Refresh has timed out, please reduce query time."

[mitsu]

Receiving the following error while refreshing the Excel from One drive-Business   "Refresh has timed out, please reduce query time."  The Excel has the Power Pivot which reads from the on Prem Analysis Service .  I am trying to refresh the same using Personal Gateway  any ideas on what would cause this. 

[Greg_Deckler]

May have just been a hiccup, or is this occurring frequently? How big is your Excel file?

[mitsu]

The Excel file is about 14 MB . Its happened a couple of times ...

[Greg_Deckler]

What kind of pipe do you have between on-premises and the Internet? I would imagine that is where the hiccup is occurring, although you couldn't 100% rule out Power BI to OneDrive. 

There is also now the option of ExpressRoute to Power BI so that might be an option.

[mitsu]

The refresh is scheduled using the Personal Gateway .Have watched it for  few days now and the  message keeps coming up . Would appreciate a Direction or any pointers to resolve the same .

[dimazaid]

hi @mitsu,
we're taking a look at this issue. Will let you know what we think the issue is once we figure it out.
Thanks,
Dimah

[mitsu]

Thank You  for looking into this.