Forum Discussion

cramkumar86's avatar
cramkumar86
Frequent Visitor
2 years ago

How to pass parameters to SQL query

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.

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.