Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.