Excel Power Query SSAS Refresh Timeout

[alexc]

Hi all, 

I have a Excel power query data model connected to Azure SQL Server Analysis Services as my data source. It has been impossible to refresh even 40K rows as the refresh automatically times out after 600 seconds. I have searched for lots of similar issues on the forum and included a CommandTimeout = #duration(0,1,30,0) but that did NOT change anything... The operations still got cancelled after merely 600 seconds. 

Can anyone help me with this or perhaps give me some guidance on where to start? 

Thank you so much

[v-lid-msft]

Hi  @alexc ,

Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.

Best regards,

[v-lid-msft]

Hi @alexc ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @alexc ,

Could you please try to increse the connection timeout value as well? Such as following:

let
  Source = AnalysisServices.Database(server as text, database as text, [CommandTimeout=#duration(0,2,0,0),ConnectionTimeout=#duration(0,2,0,0)])
in
  Source

Please refer to following document about it: https://docs.microsoft.com/en-us/powerquery-m/analysisservices-database

Best regards,

[Greg_Deckler]

That sounds odd. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".