0

I can call from SSRS BiqQuery SP when I put parameter manually (, but when I try to give report parameter to SP I got this error message.

"Error [42000] [Simba]Bigquery Invalid query: Syntax error: Expected end of input but got identifier "MyDataset" at [1:1]

enter image description here

markalex
  • 8,623
  • 2
  • 7
  • 32
SunJun
  • 1
  • 1

1 Answers1

0

You can use ODBC positional parameters with BigQuery.Declare your SSRS parameters on BQ and after that try again. Pay attention to the order.

Example:

DECLARE parameter1 = ?; DECLARE parameter2 = ?;

SELECT * FROM xxx WHERE clause1=parameter1 AND clause2=parameter2;

Here's a link; Can ODBC parameter place holders be named?

Yasin Ömer Kara
  • 1
  • 1