Power BI Report Builder crashes after I connect to ODBC data source and use parameter

[carolwu]

Hi All,

I am using Power BI Report Builder to connect to Athena datasource by using ODBC. 

I created Data Sources and Datasets with no issues.  And I added one parameter, name is p_ccy

In my dataset, I used query : select * from Currency where ccy =?

Everytime when I try to set up the ? matches parameter p_ccy. The report builder crashes by itself with no error.

Anyone has idea how to resolve it?

Thanks a lot!

[carolwu]

Hi,

Thanks for the reply.

I downloaded the latest Power BI Report Builder before I design this report. 

I did follow the correct steps to add report parameter. But still the Power BI report Builder crashes by itself.

I can connect to Postgres DB by using ODBC with no problem, I mean I can pass parameters to Postgres DB query with no problem.

[Anonymous]

Hi @carolwu 

Please update your report server to the latest version. 

If you want to use query parameters on it, please design your report with 'report builder' and refer to the following link to use 'query parameter' to create a report parameter:

Tutorial: Add a Parameter to Your Report (Report Builder) 

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.