How to pass parameters to SQL query

cramkumar86 — Wed, 19 Jun 2024 12:01:58 GMT

HI,

I have a report that connects to Impala using ODBC connector that doesnt support direct query. I am using ODBC connector here, as the native Impala connector does not work as expected in our organization for other reasons.

I have a small query that returns a single date. The query is named as me_date. Now, I would like to pass this date to another Impala query that fetches fact data. How do I achieve this? I tried using dynamic M parameters, but that is not supported for Import option. Please help.

Note: I am using PBI report server to publish reports.

Re: How to pass parameters to SQL query

lbendlin — Wed, 19 Jun 2024 21:25:12 GMT

Unfortunately is not only the combined setup unsupported, but every single component of your setup isn't supported on its own either.

See if you can get the default driver to work (with implied query folding) or if you can use a different data source, or if you can use Power BI Service.

topic Re: How to pass parameters to SQL query in Report Server

How to pass parameters to SQL query

Re: How to pass parameters to SQL query