Forum Discussion

mkbytes's avatar
mkbytes
Regular Visitor
5 years ago

Cannot Publish a Pbix file

Hello, We are running October 2020 version of PBI report server on prem. Paginated reports are currently in use, but we cannot upload a pbix report. I'm currently using the matching PBI desktop vers...
Report Server On premises
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I think i found something related to the error in the log file:

 

DataMashup.Trace Warning: 24579 : {"Start":"2020-11-03T17:57:53.4940584Z","Action":"PBI.PQ.SaveDiscardInternal","actionId":"SaveDocumentInternal","entryPoint":"EditorRibbonButtonPowerBISharePublish","errorCode":"ServerNotReachable","message":" at Microsoft.PowerBI.Client.Windows.SSRSService.SSRSPbixFile.<Save>d__28.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.PowerBI.Client.Windows.Services.FileManager.<CopyTempToFile>d__33.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.PowerBI.Client.Windows.Services.FileManager.<TrySaveBIPackage>d__28.MoveNext()","wasRetried":"False","retryReason":"","parentId":"3e812f42-1646-402f-8a7d-0a0917f1849d","isError":"True","sessionId":"799ac05d-4377-4271-ac85-ed4a70c77d39","deviceId":"9ba80868","userId":"a657900e-f028-4bd5-8356-fbbdf604c574","isInternal":"False","authenticatedUserId":"Unknown","ProductVersion":"2.86.961.0 (20.10)","ActivityId":"2296ae04-f5e4-43af-ade5-de2d7aec9ab2","Process":"PBIDesktop","Pid":116108,"Tid":1,"Duration":"-00:00:00.0002562"}
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Maybe this can be of help as well. These lines are just above the previous line:

 

DataMashup.Trace Information: 24579 : {"Start":"2020-11-03T17:57:53.2410690Z","Action":"JsonSerializer/TryDeserialize","Result":true,"ProductVersion":"2.86.961.0 (20.10)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":116108,"Tid":1,"Duration":"00:00:00.0001546"}
DataMashup.Trace Information: 24579 : {"Start":"2020-11-03T17:57:53.3424864Z","Action":"JsonSerializer/TryDeserialize","Result":true,"ProductVersion":"2.86.961.0 (20.10)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":116108,"Tid":1,"Duration":"00:00:00.0002794"}
DataMashup.Trace Warning: 24579 : {"Start":"2020-11-03T17:57:52.9604204Z","Action":"PBI.Win.SaveReportToSSRS","result":"ServerNotReachable","parentId":"3e812f42-1646-402f-8a7d-0a0917f1849d","isError":"True","sessionId":"799ac05d-4377-4271-ac85-ed4a70c77d39","deviceId":"9ba80868","userId":"a657900e-f028-4bd5-8356-fbbdf604c574","isInternal":"False","authenticatedUserId":"Unknown","ProductVersion":"2.86.961.0 (20.10)","ActivityId":"e544a76c-8bef-4b89-9183-c7ed7430ba71","Process":"PBIDesktop","Pid":116108,"Tid":1,"Duration":"00:00:00.5262420"}

The part where it says  "authenticatedUserId":"Unknown", may have something to do with the error!?

When I run go to the Report Server web UI I always have to put in my credentials in a basic dialog. I am using the same credentials when publishing the report. But I get the feeling that our report server somehow does not pick up the AD-user when using Google Chrome.

  • Petebro's avatar
    Petebro
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    Are you running basic, custom auth or windows authentication on the report server?

     

    https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-ver15

     

     

    I'm guessing since you mentioned AD the answer is windows, and you're hitting an issue with your windows username not being listed explicitly in the security settings of your Report Server, but the user is an admin on the machine (and thus part of the builtin\admins group which is listed). The solution could be to explicitly list your username in a folder (or root) security tab of the report server.

     

    To do this you can run chrome, edge, or IE as administrator (right click on short cut-> run as administrator) then click the "manage"  button on a folder of your Report Server, then click security and add "{Domain}\{Username}" to the list with all roles. 


     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Fifth time im replying, this community server really leavs a lot to ask for...

       

      Windows auth and same error message from Desktop after putting in my usernamne with domain in the root folder on the report server (Manage Folder)