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

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

Guerrero — Fri, 19 Jul 2024 06:33:01 GMT

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.

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

Anonymous — Mon, 22 Jul 2024 02:16:36 GMT

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

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

Anonymous — Wed, 31 Jul 2024 08:46:11 GMT

Hi @Guerrero ,

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

Best Regards

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

Guerrero — Wed, 11 Dec 2024 09:38:43 GMT

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}