02-09-2022 01:11 AM
We have our BI facts and dimensions built in as delta table in Datarbicks env and is being used for reporting by connecting PowerBI reports using datarbricks connection. We now have a need to use this data for another application utilizing SSRS reports. Is there a way to connect SSRS report to the data in the delta table without replicating the data to azure sql? We do not want to use Azure Synapse on top of it. While querying the parquet file format of the delta table might be one solution but is not the most elegant one.
02-11-2022 06:20 AM
I know we've been able to successfully connect Power BI Service to Databricks via the Simba Spark ODBC driver installed on a PBI Gateway server. I haven't gone into trying through our SSRS server yet. I suspect it is likely possible if network and drivers are configured correctly.
02-10-2022 07:36 AM
Hi, @Matt M - Welcome back! I'm sure the community will respond soon. Thank you for your patience. 🙂
02-11-2022 06:20 AM
I know we've been able to successfully connect Power BI Service to Databricks via the Simba Spark ODBC driver installed on a PBI Gateway server. I haven't gone into trying through our SSRS server yet. I suspect it is likely possible if network and drivers are configured correctly.
02-16-2022 07:57 AM
Like @Ryan Daly said, you can do this "natively" using Databricks SQL (since SSRS and other tools can "see" the SQL endpoint can communicate with it via ODBC (using the Simba Spark driver). We have integrated this way with PowerBI, SSIS, SSRS, desktop SQL IDEs, Tableau Desktop/Server, etc.
02-21-2023 10:51 PM
Could you please let me know how to configure the SimbaSpark ODBC driver with databricks
08-10-2023 05:47 PM
Hi @Chris_Grabiel , I was following the post as facing some issue while deploying the SSRS report to the desired SSRS server instance. I was able to retrieve the data in SSRS (visual studio) from data bricks using end point ODBC connector. However, when I am deploying the report to SSRS server there is error and when I check the SSRS server instance I can see that connection is unable to build. Although I have installed the same ODBC connector on server machine. I am using the connection string Dsn=eduschedargdevmanagedrgdbw01 on SSRS server. Looking forward to hearing from you soon. Cheers,
02-16-2022 08:02 AM
Thanks AgCountry FCS (Customer) and Chris Grabiel (Customer)
02-16-2022 08:48 AM
@Matt M - Would you be happy to mark whichever answer provided your solution as best so other members may find the solution more quickly?
03-19-2022 04:18 AM
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group