- 14007 Views
- 6 replies
- 2 kudos
Hi All, I'm wondering if anyone has had any luck setting up multi valued parameters on SSRS using ODBC connection to Databricks? I'm getting "Cannot add multi value query parameter" error everytime I change my parameter to multi value. In the query s...
- 14007 Views
- 6 replies
- 2 kudos
Latest Reply
Hi I am working on having SSRS reports access Databricks and facing similar challenges. I see you tried this back in 2022. Can you please advice the approach to handle the multi value parameters? Thanks Sam
5 More Replies
by
wyzer
• Contributor II
- 9187 Views
- 8 replies
- 4 kudos
Hello,In SSRS/Power BI (report builder), how to query a table in Databricks with parameters please ?Because this code doesn't works :SELECT * FROM TempBase.Customers WHERE Name = {{ @P_Name }}Thanks.
- 9187 Views
- 8 replies
- 4 kudos
Latest Reply
Hi, I am not able to see the data in SSRS while I am using date parameters but with manual dates data is populating fine. The database is pointing to databricks. I am not sure what I am missing here. Please help me in this. ThanksI am trying with que...
7 More Replies
- 6924 Views
- 6 replies
- 12 kudos
Has anybody succeeded in querying Databricks SQL with an on-prem SSRS (so an on-prem Report Server and Report Builder)?I manage to create a connection that works (according to the connection test anyway), but the moment I try to create a dataset on t...
- 6924 Views
- 6 replies
- 12 kudos
Latest Reply
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 t...
5 More Replies
by
Ronis
• New Contributor
- 6865 Views
- 4 replies
- 1 kudos
Hi ,I need to connect databricks query from microsoft SSRS.is it possible ? How do you make the connection?
- 6865 Views
- 4 replies
- 1 kudos
Latest Reply
@Haider93 https://www.databricks.com/company/partners/technology This is the list of supported databricks technology partners. SSRS is not yet part of it. We do have official support for Power BI. You can use this document to mimic it for SSRS - http...
3 More Replies
- 2580 Views
- 3 replies
- 1 kudos
I am trying to pass parameter from SSRS to User Defined Function in Databricks which in turn will return table that will be shown as output in report.I tried below calling function from SSRS, but it looks like parameter value is not passed. I have di...
- 2580 Views
- 3 replies
- 1 kudos
Latest Reply
can you share full code and dataset by that we can also debug this
2 More Replies