POwer BI RS - Unable to deploy reports/manage previously deployed reports
Good morning all. Spent the last few days going around in circles trying to fix an issue that seems to have appeared at work this last week or so. We noticed that some of our power BI reports deployed to the report server are now not accessible. You can't manage them in the application (Getting a "An error has occurred. Something went wrong. Please try again later." message), unable to delete. Trying to deploy and looking in the logs and it's complaining about the file not being found (). If I start on PBI RS App and try and open a report from the report server, I can navigate to the server and through the folders and see the files, but on selecting I get an error ("ERROR Unexpected Error Encountered"). RSPowerBI Log showing this issue: 2024-05-02 09:24:59.1772|FATAL|1|Could not start PBIXSystem.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: Access is denied RSOffice Log showing this issue: FATAL|1|Could not start OfficeSystem.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: Access is denied RSHosting Service Showing this: 2024-05-02 01:24:52.8024|INFO|41|Launching Process : Office 2024-05-02 01:24:52.8024|INFO|41|Starting Process: H:\Power BI Report Server\PBIRS\Office\RSOffice.exe 2024-05-02 01:24:54.2557|INFO|37|Launching Process : PowerBI 2024-05-02 01:24:54.2557|INFO|37|Starting Process: H:\Power BI Report Server\PBIRS\PowerBI\RSPowerBI.exe 2024-05-02 01:24:55.1621|WARN|7|Child Process [Office] Died. Check the log for further information 2024-05-02 01:24:57.7876|WARN|7|Child Process [PowerBI] Died. Check the log for further information RSPortal Log when I tried to : 024-05-02 09:46:03.3433|INFO|1075|Received request GET /api/v2.0/CatalogItems(Path='XXX')| RequestID = s_698e533e-a4bb-4007-816c-a152be3a6ec0 2024-05-02 09:46:03.3589|ERROR|1075|OData exception occurred: System.Net.WebException: The remote server returned an error: (404) Not Found. Other things that are happening also are say trying to save a report to report server and getting file is too big when it's an empty pbix.
Migrate power BI report between two Power BI report server environment (on-premises)
Hi there, We want to set-up a deployment strategy, we have three Power bi report server environment (dev,test,prod) . we just use power bi desktop and Power BI report server. Our deployment strategy will be: -Developers publish reports from the power bi desktop to the dev environment -Admin will migrate reports from dev to test environment -Admin will migrate reports from test to prod environment the first step is retrieving catalog item, i can see the power bi report (ADW_adventures). when migration start, i get errors for powerBIReport Error: Migrating PowerBIReport: /source/data/ADW_adventures System.Web.Services.Protocols.SoapException: The item '/source/data/ADW_adventures' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/source/data/ADW_adventures' cannot be found. at Microsoft.ReportingServices.Library.ReportingService2010Impl.GetItemDefinition(String ItemPath, Byte[]& Definition) at Microsoft.ReportingServices.WebServer.ReportingService2010.GetItemDefinition(String ItemPath, Byte[]& Definition) Do you have any insights why I’m getting the error? do you know if there is other solution for the deployment strategy? Thanks Pascal
PowerShell - deploy and Update PBIX on Report Server
Hello Community, I have used theses lines in order to deploy a pbix file on Report Server : $session = New-RsRestSession -ReportPortalUri http://lservername/Reports Write-RsRestCatalogItem -WebSession $session -Path "C:\2019\mypbix.pbix" -RsFolder "/MyFolder" It is working fine. Now, when I need to update the bix with another version , I used the same command bellow but I am getting this error : Write-RsRestCatalogItem : System.Exception: Failed to create catalog item: The remote server returned an error: (409) Conflict. ---> System.Net.WebException: The remote server returned an error: (409) Conflict. at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request) at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord() --- End of inner exception stack trace --- At line:1 char:1 + Write-RsRestCatalogItem -WebSession $session -Path "C:\2019\PwC Acade ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-RsRestCatalogItem Does any one please have an idea about hte command PowerShell that could update apbix previously on the Server please by a new version ? Many thanks Best Regards, Asma
New installation of power-bi on-premises
Hi, A new installation of the power-bi on-premises was installed in our server. I did manage to configure the power-bi part, but now the report server part is giving me an error: Invalid name space. I think it has to do with the fact that there are two ssrs servers installed in one machine, but I am not sure what to do. Also, I am trying to deploy a power bi report into the on-premises server, but I am not sure how. From the desktop it only lets me deploy to the cloud. How do I fix that? Thanks AstridCannot deploy rdl file to Power BI Report Server
We're trying out Power BI Report Server (trial version 15.0.2.402) and are unable to deploy an .rdl (using VS 2014) or upload using Portal URL. Attempting to deploy using VS 2014 we continue to get Login box with Username and Password, which keeps popping up each time we try with Admin credentials. Using the web portal we get "An error has ocurred. Something went wrong. Please try again later." We can upload a simple .txt file however (?). Here's part of the RSPortal log file that shows the error: "System.Net.WebException: The request failed with HTTP status 401: Unauthorized." We are able to upload .pbix type analytics reports (?) 2018-08-24 13:11:18.6033|INFO|52|CFG : AccessControlAllowCredentials = [false] (env) 2018-08-24 13:11:18.6033|INFO|52|Received request GET /assets/fonts/powerbiglyphs-regular.woff| RequestID = s_cbfe053b-aedb-43a6-99ad-d47e7691f1b6 2018-08-24 13:11:18.7153|INFO|52|Received request GET /api/v2.0/catalogitems%284f81527a-db55-46b1-9bdd-6f442e1c3489%29/Model.Folder/catalogitems/| RequestID = s_bfe11654-f05e-4c56-897c-e52937f6ed46 2018-08-24 13:11:18.7153|INFO|53|Sending response. Response code xxxxx\xxxxxxxxxx 200, Elapsed time 0:00:00.0141077| RequestID = s_bfe11654-f05e-4c56-897c-e52937f6ed46 2018-08-24 13:11:25.2322|INFO|52|Received request POST /api/v2.0/catalogitems| RequestID = s_8f81945e-d7bb-4069-b47e-32ec5d2c5ef5 2018-08-24 13:11:27.2728|ERROR|52|OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetConnectionProtocol() at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol) at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.CreateCatalogItem(String itemType, String name, String parent, Boolean overwrite, Byte[] definition, Property[] properties, Warning[]& warnings) at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass1.<CreateCatalogItem>b__0() at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func) at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.CreateReport(RSService rsService, IPrincipal userPrincipal, String reportName, String parentFolder, Boolean overwrite, Byte[] definition, Property[] properties) at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.CreateItem(IPrincipal userPrincipal, CatalogItem catalogItem, CatalogItem& createdItem) at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CatalogItemsController.AddEntity(CatalogItem entity, CatalogItem& createdEntity) at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.Post(ODataPath oDataPath, T value) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) --- 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 System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.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 System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.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 System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext().| RequestID = s_8f81945e-d7bb-4069-b47e-32ec5d2c5ef5 2018-08-24 13:11:27.2728|INFO|53|Sending response. Response code xxxx\xxxxxxxxxxx 500, Elapsed time 0:00:02.041152| RequestID = s_8f81945e-d7bb-4069-b47e-32ec5d2c5ef5 Any help is greatly appreciated, as we'd like to use the tool but cannot even fully evaluate it at this time.
