Timeout when querying Analysis Services

[Phil_Seamark]

In Power BI Desktop, when trying to run or refresh an MDX query against a local SSAS server, Power BI starts trying to kill the query after 60 seconds.  I know the query works fine from SQL Server Management Studio and typically takes around 90 seconds which I am ok with for this particular query.

Is there anywhere I can set or override timeout when using the AnalysisServices.Database function?

Cheers,

Phil

[v-sihou-msft]

@Phil_Seamark

To add timeout property in connection string and use it in Power Query, you may use OleDb.Query function. Please refer to blog: Running Your Own MDX And DAX Queries In Power BI Desktop.

Another option is set the SSAS server property ExternalCommandTimeout and ExternalConnectionTimeout to 0.

Regards,

Simon Hou

[Phil_Seamark]

Cheer Simon,

I will have a look into this.  The other option I guess is ODBC which may also have some timeout properties I can set. 

It's definitely coming from the client as other clients can run these (and other longer queries) without being killed.