Forum Discussion

WM117's avatar
WM117
Frequent Visitor
2 years ago
Solved

DataSource.Error: Microsoft SQL: Must declare the scalar variable

Hi everybody,   I get this error message in PowerQuery "DataSource.Error: Microsoft SQL: Must declare the scalar variable @Jaar" In these lines of code. The issue seems to be Year(start)=@jaar.   ...
  • Syndicate_Admin's avatar
    2 years ago

    Exactly as the error message says - you need to provide the value of that variable, or replace it with a static value.