After making a roll and saving it, power bi hangs.

[Guerrero]

When i use Juny 2024 Vesion work nice but when i use July 2024 update rollen Hangs( no respons).
Release:
July 2024

Product Version:
2.131.901.0 (24.07) (x64)

OS Version:
Microsoft Windows NT 10.0.20348.0 (x64 nl-NL)

After making a roll and saving it, power bi hangs.

Help please. 

[Guerrero]

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...","executionDuration":19}

[Anonymous]

Hi @Guerrero ,

Whether your problem has been resolved? If yes, could you please mark your post as Answered? Thank you.

Best Regards

[Anonymous]

Hi @Guerrero ,

Based on your description, it appears that Power BI hangs when you create and save a new role. I have tested this scenario with different versions of Power BI Desktop but was unable to reproduce the issue. Could you please confirm if the problem still persists on your end?

Power BI Desktop Version: 2.130.930.0 64-bit (June 2024)

Power BI Desktop Version: 2.131.901.0 64-bit (July 2024)

Best Regards