Forum Discussion
After making a roll and saving it, power bi hangs.
Goedmorning.
Im using pipeline in fabric en I want to pass parameters to a nootbook T-SQL ,
what is wrong hier :
from pipeline parameters
Bestand
IcrField
IncDatum
{
"notebookId": "599ed485-5c5e-4ef6-8622-bb0739d1c35d",
"workspaceId": "d0a12fde-ef49-45c6-934a-b898d14a0916",
"parameters": {
"Bestand": {
"value": "BEROEP",
"type": "string"
},
"IcrField": {
"value": "MUTATIEDATUM",
"type": "string"
},
"IncDatum": {
"value": "2024-09-14T00:00:00Z",
"type": "string"
}
}
}
DECLARE @Bestand VARCHAR(20);
SET @Bestand = {Bestand}; -- Substitute parameter safely, e.g. "BEROEP"
DECLARE @IcrField VARCHAR(20);
SET @IcrField = {IcrField}; -- Substitute parameter safely, e.g. "MUTATIEDATUM"
DECLARE @IncDatum DATETIME;
SET @IncDatum = CAST({IncDatum} AS DATETIME); -- Convert string to DATETIME, e.g. '2024-09-14T00:00:00Z'
PRINT @Bestand;
PRINT @IcrField;
PRINT @IncDatum;
i used de paramers of diferent sintaxi, but every time get errors.
is another way to define de parameter in de Nootboek T-SQL?
this is de error;
{"status":"Failed","result":{"runId":"870ebb29-bff2-4aa4-b0cd-39b1e4a77aab","runStatus":"Failed","sessionId":null,"sparkPool":"d0a12fde-ef49-45c6-934a-b898d14a0916","error":{"ename":"DatawarehouseExecuteSqlError","evalue":"Incorrect syntax near '}'.\r\nIncorrect syntax near '}'.\r\nIncorrect syntax near '}'. Data warehouse trace id: 491cd76b-1e2a-408e-88fe-9b28e8061ece","traceback":null},"lastCheckedOn":"2024-12-11T09:19:50.71Z","metadata":{"isForPipeline":null,"runStartTime":"2024-12-11T09:19:47.5468699Z","runEndTime":"2024-12-11T09:19:50.7086912Z"},"highConcurrencyModeStatus":null,"exitValue":null},"message":"Notebook execution is in Failed state, runId: 870ebb29-bff2-4aa4-b0cd-39b1e4a77aab","SparkMonitoringURL":"https://app.powerbi.com/workloads/de-ds/sparkmonitor/599ed485-5c5e-4ef6-8622-bb0739d1c35d/?trident=1&experience=power-bi&tab=data","executionDuration":19}