When will azure Databricks parameter markers be supported in Report Builder?

Question

When will azure Databricks parameter markers be supported in Report Builder?

Thomas Perkins 15

Parameter markers were released to support the use of named parameters within complex queries running on an Azure Databricks environment. https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-parameter-marker I'm curious when these or other similar functionality might be available inside of SSRS or Report Builder to allow for more complex querying of Databricks in Reporting Services?

0 comments

1 answer

Your answer

Answer 1

ZoeHui-MSFT 41,551

Hi @Thomas Perkins,

For Suggestions/Other Ideas: Tell us how this impacts your business operations and how what you're asking for will enable/unblock your scenario.

You may raise your idea here.

If the idea has been voted, the product team will consider adding the feature.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Thomas Perkins 15 Reputation points

2024-02-19T16:41:48.7866667+00:00

Like many BI teams using SSRS, we have hundreds of complex parameterized reports that are used in core parts of our business. Without some ability to pass parameters to our Databricks environment, we cannot effectively use Databricks as a source. We expect that being able to transition those reports to run on our Databricks environment would improve the performance of these report by a huge margin.
Thomas Perkins 15 Reputation points

2024-02-19T16:53:20.8133333+00:00

I took your advice and submitted the idea here. https://feedback.azure.com/d365community/idea/bee599e5-46cf-ee11-92bc-000d3a033659
ZoeHui-MSFT 41,551 Reputation points

2024-02-20T01:12:01.7366667+00:00

Good job!

Share via

When will azure Databricks parameter markers be supported in Report Builder?

1 answer

Your answer