Recently one of mine friend was facing the error while processing SSAS model on azure instance and he searched a lot on internet but did not found the solution. Might be he missed some posts so I thought to share the one so if others face same issue then this post may help.
He was trying to process SSAS model on SSAS Azure instance and he encountered following error
Error returned: 'OLE DB or ODBC error: Received error payload from gateway service with ID 2330343: An exception encountered while accessing the target data source
This was not a major issue because he has created SSAS model using 1200 compatibility and tried to process the same on Azure instance. Issue was resolved after changing the "Compatibility Level" to "SQL Server 2017/Azure Analysis Services (1400).
1. Open your SSAS model using SSDT and right click on "Model.bim" and select "Properties" option.
2. Under model properties, change "Compatibility Level" to "SQL Server 2017/Azure Analysis Services (1400).
3. Close the SSDT and reopen again and deploy the solution again and try processing.
He was trying to process SSAS model on SSAS Azure instance and he encountered following error
Error returned: 'OLE DB or ODBC error: Received error payload from gateway service with ID 2330343: An exception encountered while accessing the target data source
This was not a major issue because he has created SSAS model using 1200 compatibility and tried to process the same on Azure instance. Issue was resolved after changing the "Compatibility Level" to "SQL Server 2017/Azure Analysis Services (1400).
1. Open your SSAS model using SSDT and right click on "Model.bim" and select "Properties" option.
2. Under model properties, change "Compatibility Level" to "SQL Server 2017/Azure Analysis Services (1400).
3. Close the SSDT and reopen again and deploy the solution again and try processing.