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.
Hi,
ReplyDeleteI had a similar problem when building a tabular model. I need to import 6 tables from an Oracle machine. 2 of them are OK, the others were not added, with this error :
Failed to save modifications to the server.
Error returned: 'OLE DB or ODBC error: Received error payload from gateway service with ID 2302288:
An exception encountered while accessing the target data source..
I tried to do what you have described as a possible solution, but it didn't make a difference. I'm no Oracle expert, so I can't really figure out what to do here.
The difference between the 2 successful tables and the tables that were not added is that the successful ones are actual tables in Oracle, the others are views based on a query. Could that be the problem?
hey... Great work . I feel nice while i reading blog .You are doing well. Keep it up. We will also provide dial QuickBooks Support Number to reach us call to 1-855-756-1077 for instant help.
ReplyDeleteNice & Informative Blog !
ReplyDeleteQuickBooks is a popular accounting application that provides efficient and systematic solutions for organizations of all sizes. Any fraudulent mistake in QuickBooks software can be easily rectified by our experts at QuickBooks Customer Support Number 1-855-974-6537.
Nice Blog !
ReplyDeleteIf you see QuickBooks Error 106 on your screen,We make sure to give you the best service for QuickBooks at an affordable rate.
Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.If you face any issue in QuickBooks, contact:
ReplyDeleteQuickBooks Customer Service phone numberFor quick solution.