Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2023 12:08 AM
Hi @-werners- ,
I am able to build connection between Microsoft visual studio and data bricks using Simba Spark ODBC driver. I can query delta tables sitting in Databricks from Microsoft Visual studio (SSRS). However, when I am deploying the report to reporting service the report deploy successfully but upon opening the SSRS I can see the following error. "
- An error has occurred during report processing. (rsProcessingAborted)
- The execution failed for the shared data set 'sdtst_CG'. (rsDataSetExecutionError)
- Cannot create a connection to data source ' Data source for shared dataset'. (rsErrorOpeningConnection)
- ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
I have setup ODBC on server side and test the connection its successful but the connection is not flowing to SSRS for some reason. Can you please guide me on that.