topic Re: Unable to open any files on power bi report server in Report Server

Unable to open any files on power bi report server

pabeader — Thu, 18 Mar 2021 16:40:26 GMT

I am getting this error message:

"Sorry, you don't have permission to open this file. Please choose a different file and try again."

I am the administrator.

This is on any file I try to open. Also, I can't open from the portal either. I get a different error message related to Server Unavailable.

Any help will be greatly appriciated.

Re: Unable to open any files on power bi report server

pabeader — Thu, 18 Mar 2021 18:49:10 GMT

After some further testing. It's only me that is having this issue. Others are able to open and modify with no issues.

Re: Unable to open any files on power bi report server

pabeader — Fri, 19 Mar 2021 13:31:14 GMT

Tried deleting the entry in Web Credentials but that didn't help.

Re: Unable to open any files on power bi report server

pabeader — Fri, 19 Mar 2021 13:57:23 GMT

Most recent peice of information....

Re: Unable to open any files on power bi report server

Anonymous — Mon, 22 Mar 2021 06:31:03 GMT

pabeader

Can you open with right click and run as admin?

Do you mean you cannot open both report builder and web portal of report server? Please check if your account have the permission to access the database that both report builder and report server connected, e.g sql server db.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Re: Unable to open any files on power bi report server

pabeader — Mon, 22 Mar 2021 15:45:18 GMT

I'm not sure what you mean by "account have the permission to access the database that both report builder and report server" I can download and upload and do everything else on the Report Server. It's when I'm trying to use the Edit in Power BI option or Open from Power BI Report Server that I get error messages.

Re: Unable to open any files on power bi report server

pabeader — Wed, 24 Mar 2021 16:11:41 GMT

Still looking for help with this. Any ideas would be greatly appriciated.

Re: Unable to open any files on power bi report server

AbhiSSRS — Wed, 31 Mar 2021 14:06:06 GMT

You have to assign yourself along with others in Roles despite already being an admin for the server. The access to report folder would still need to be given to your id exclusively.

Re: Unable to open any files on power bi report server

pabeader — Wed, 31 Mar 2021 14:07:53 GMT

When did that change? It worked one day and then didn't work the next.

Re: Unable to open any files on power bi report server

AbhiSSRS — Wed, 31 Mar 2021 14:12:57 GMT

Could you please have that checked ? I am referring to teh roles assignment on Reports/folders to ids. Please have it assigned for your id.

Is tnapowerBI teh account used to configure or as ExecutionAccount in configurator or as an Impersonate account in datasets?

Re: Unable to open any files on power bi report server

pabeader — Thu, 01 Apr 2021 01:41:27 GMT

Nothing can have changed on the Report Server, roles, IDs or whatever. It worked fine at

10 AM and was messed up at 11:00 AM. Not sure where tnapowerbi came from. To the best of my knowledge, there is no account with that id. I've pretty much given up and just download and upload. It's just very annoying that it only is doing this to me. Every other person is able to use it like they always have.

Re: Unable to open any files on power bi report server

pabeader — Tue, 08 Jun 2021 17:49:56 GMT

Still wondering if anybody has any new ideas. If I login as my alter ego I can Edit file from the portal and I can open file from the server. I just need to know where to go to correct this for my regular user.

Here is the copy from the error message.

Feedback Type:
Frown (Error)

Error Message:
Server is not reachable

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(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, IQueryServices queryServices, IOpenSaveUI openSaveUI, TelemetryUserActionId entryPoint, IPbixFile pbixFile, Boolean fromRecentFile)
at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.OpenFileFromSSRSService(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, IQueryServices queryServices, TelemetryUserActionId entryPoint, Uri reportUri, Boolean fromRecentFile)
at Microsoft.PowerBI.Client.Windows.MainWindow.OpenFromSSRSService()
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_7.<<Main>b__7>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__113_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()

Stack Trace Message:
Server is not reachable

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()
at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.MainWindow.<ActivateMainWindow>b__113_0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

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

Snapshot Trace Logs:
C:\Users\pieciakb\AppData\Local\Microsoft\Power BI Desktop SSRS\FrownSnapShot51046441-d7ec-4c82-a4e3-d30fe72ef50f.zip

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Performance Trace Logs:
C:\Users\pieciakb\AppData\Local\Microsoft\Power BI Desktop SSRS\PerformanceTraces.zip

Enabled Preview Features:
PBI_NewWebTableInference
PBI_ImportTextByExample

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_JsonTableInference
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_eimInformationProtectionForDesktop
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_cartesianMultiplesAuthoring
PBI_enhancedTooltips

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBIUserFeedbackServices_IsReported:
True

Formulas:

section Section1;

Re: Unable to open any files on power bi report server

pabeader — Mon, 28 Jun 2021 17:27:54 GMT

I found a way around this issue. Use the ip address of the report server, instead of the name. Works for me, hopefully it works for you.