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

[WM117]

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.

Does anybody know how to solve this? 

SELECT 
	 Academy
	 ,Soort
	 ,EvenementID
	,Start
	,Omzet
	,AantalDagen
	,Trainer
	,PercentageMarketingKosten/100 * Omzet as Marketingkosten
	,LocatieBerekend
	,Locatie
	,CommissieVergoeding
	,Commissie

	,Omzet
		- PercentageMarketingKosten/100 * Omzet 
		- Trainer
		- Locatie
		- Commissie

	as Brutomarge

	,Overig
	
		
FROM tl.v_Projectadministratie
WHERE OmzetLaptops=0
and Year(start)=@Jaar
and Trainer<>0
AND Start<= GETDATE()-30
ORDER BY Start DESC

[Syndicate_Admin · Accepted solution]

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