Forum Discussion

Anonymous

Not applicable

4 years ago

Direct query - DECLARE Statements

Hi, I'm using a direct query PBI SQL query with DECLARE statement. It throws me an error saying that Incorrect syntax near the keyqord DECLARE. Incorrect syntax near ')' The SQL statement ...

Need Help

amitchandak

Super User

4 years ago

Anonymous , where are you using this @effect_date date? this, you can use as a sub query.

Also checking after using this query is it still working on power bi service.

Forum Discussion

Direct query - DECLARE Statements

Related content

Declaring SQL variables in Notebooks

SQL Declare Statements in Power BI

OR Statement ?

Paginated reports: getting error that parameter not declared though I properly declared it

SQL SSRS Declare Statement in Power BI