Paginated Report parameter passing in query

Hi SakshiWalia_06 ,

I'm not sure if the syntax is exactly the same for Oracle and Redshift, but the screenshot you provided of the error report is entirely due to a syntax error in the query statement you are using. Please look up the Redshift documentation and check your query code for syntax errors, especially in the more detailed areas like punctuation, where errors are more likely to occur.
I would suggest you to run it in Redshift database first, and then copy it to Power BI Report Builder if you can run it successfully. For parameters, you can define one or two variables in the database to simulate the parameters of the whole paging report, so that you can avoid the whole problem.

If you still can't solve it, please provide me with the Oracle query code that runs successfully.

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