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

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

Hi Guerrero ,

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

Best Regards

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}