Forum Discussion

jayrey48's avatar
jayrey48
Regular Visitor
1 year ago

How to pass a Report Builder parameter to Athena via text query?

Hi all -  I'm developing a paginated report in Report Builder with Athena as a data source via ODBC. The final report is published to Power BI service with an On-Prem Gateway, which is working fine....
Need Help
jayrey48's avatar
jayrey48
Regular Visitor
1 year ago

Thanks for the response. 

 

I have already verified all of the above. Athena will not accept the "@parameter" or "in (@parameter)" syntax - it has to be the ? in the query in Power BI Report Builder. And a multi-value parameter is not allowed by Athena.

This is the error message I get when trying the "thing3 = @Parameter" construct:

ERROR [HY000] [AmazonAthena][AthenaClientError]: ExceptionName: InvalidRequestException, ErrorType: 130, ExceptionMessage: line 74:12: mismatched input '='. Expecting: <predicate>

 

Please advise whether this is something that the application does not allow and how I can submit a feature request if not. Again, this works as a filter but not a query parameter.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi jayrey48 ,

    I'm a little confused. Did you apply the query with the parameter in Athena or Report builder? The previous reply is base on the report builder, and the "?" can't be used as paremater name...

    Best Regards