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 Ma...
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.