Power BI Desktop cannot open report from Report Server unexpected error

[seme]

Hi at all,

We are using Power BI report server on-premise. Unfortunately we encounter an error when trying to edit reports in Power BI Desktop. The issue can be reproduced:

• when clicking the three dots beside an report on report server
• choose "Edit in PowerBI Desktop"
• Power BI Desktop starts on the local computer but shows "unexpected error encountered"

When donwloading the report to the filesystem and open it in PowerBI Desktop, everything is working as aspected. Afterwards the report can be uploaded to Report Server again without any issues.

Any idea what the matter could be? Here are some more details and traces:

Feedback Type:
Frown (Error)

Timestamp:
2022-06-09T06:57:37.6624896Z

Local Time:
2022-06-09T08:57:37.6624896+02:00

Session ID:
346bb193-f880-44df-b670-8dd4e23bd930

Release:
May 2022

Product Version:
2.105.961.0 (22.05) (x64)

Stack Trace:
Microsoft.PowerBI.Client.Windows.Storage.FileOpenException
at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.<OpenFileInternal>d__30.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_7.<<Main>b__10>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.MainWindow.<<ActivateMainWindow>b__118_1>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.105.961.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenException","MethodDef":"HandleError","ErrorOffset":"201"}

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)

CLR Version:
4.7.2 or later [Release Number = 461814]

Peak Virtual Memory:
53.8 GB

Private Memory:
461 MB

Peak Working Set:
730 MB

IE Version:
11.1790.17763.0

User ID:
9a3169fb-72e7-40d6-be41-962de3f3a6f1

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_enhancedTooltips
PBI_mobileAuthoringFormattingUI
PBI_useModernFormatPane
PBI_sparklines
PBI_scorecardVisual
PBI_lineChartError
PBI_fieldParametersSuperSwitch

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI Report Server, Power BI

Cheers,

seme

[v-xiaoyan-msft]

Hi @seme ,

Do you need further confirmation that your Power BI Report Server and Desktop have been updated to the May version?

Will this problem still occur if I roll back one of them to the previous version?

Can this report be opened directly in Power BI Desktop or Power BI Report Server Desktop?

Best Regards,
Community Support Team _ Caitlyn

[seme]

Hi Caitlyn,

We had the same issue with older versions of PowerBI report server and PowerBI Desktop. My hope was that an update to a newer release will fix that behaviour. So a rollback unfortunately won't fix the issue.

Yes, if I download the report and open it with Power BI Desktop, everything is fine.

Any other ideas? Thank you very much in advance.

Cheers,

seme

[adrnln]

Hi, 

we have same problem from may 2022 version. Just updated to September 2022 and it was not solved. Have you found any solution for this? 

[Asf_BI]

Hi everyone,

we use sep 2022 version and we have the same problem. The wierd thing is on the server where report server is installed the "edit in power bi desktop" option works fine. However, on other computers it encounters the same error.

Any ideas to solve this problem?

Thanks

[adrnln]

Hi, 

our problem was with authentication. Computer which wanted to edit was not in same domain as server. When editing form, PowerBI Desktop is trying to connect and download form through credentials which are logged. 

[astidwiyana]

Hello, We use Jan 2024 version and have the same problem. 
Have you found any solution for this problem?