Forum Discussion
Timeout when querying Analysis Services
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
2 Replies
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
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.
