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.
I have a model in SSAS, and it is import mode, Capability is 1500,
Recently I deploy a model into the SSAS,When I process every single table, I can refresh it successfully,
When I processed the database full, It prompt the below error all the times,
Could you please advise how to fix it?
BTW, I have tried to set the SSAS server property ExternalCommandTimeout and ExternalConnectionTimeout to 0. it failed all the time.
Sorry, Attach a wrong screenshot, the error message is:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding..
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
The current operation was cancelled because another operation in the transaction failed.
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Hi @Anonymous ,
Maybe you can set both parameters to 3600 seconds and try again.
Also, how big was the data you imported?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Lionel,
Thanks for your solution, I set the Time to 3600, but it is not work,
The Previous model is in the Power Bi desktop, it is 2.5 G, and recently we migrate it to SSAS server, and enlarge the time frame , May you please indicate me how to get the data volumn info in the SSAS?
Hi, could you resolve this one?
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.