Haider93
New Contributor III

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.