Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Cannot 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.

9 REPLIES 9
mgmeyer
Power BI Team
Power BI Team

Can you check the ReportingServicesServiceXXXX log in the LogFiles folder and let me know if you see any errors?

Anonymous
Not applicable

Yes, there are several errors in the that log...  here are the relevant parts of that log:

 

rshost!rshost!1b6c!08/24/2018-15:19:14:: i INFO: Derived memory configuration based on physical memory as 4193844 KB
rshost!rshost!1b6c!08/24/2018-15:19:14:: w WARN: Failed to initialize performance counters: 2. Possible setup issue.
appdomainmanager!DefaultDomain!1b6c!08/24/2018-15:19:14:: i INFO: Entered managed ServiceMain in DefaultDomain.
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: e ERROR: Configuration file element UrlReservation has a invalid VirtualRoot. It will be ignored.

 

--

 

configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: e ERROR: Failed to get url configuration section.
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: e ERROR: Failed to get url configuration section.
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: w WARN: IsApplicationUrlSubsetOfReportServer() -- Failed to get url configuration section.
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: i INFO: Using report server internal url .
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: i INFO: Using report server external url .
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: i INFO: Using url root .

 

--

 

library!WindowsService_0!1198!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
rshost!rshost!1700!08/24/2018-15:19:17:: i INFO: Derived memory configuration based on physical memory as 4193844 KB
rpcserver!DefaultDomain!182c!08/24/2018-15:19:17:: i INFO: Process monitoring started.
servicecontroller!DefaultDomain!12a4!08/24/2018-15:19:17:: i INFO: Total Physical memory: 4294496256
library!WindowsService_0!1198!08/24/2018-15:19:17:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
library!WindowsService_0!1198!08/24/2018-15:19:17:: e ERROR: ServiceStartThread: Attempting to start service again...
rpcserver!DefaultDomain!1198!08/24/2018-15:19:17:: i INFO: RPC Server started.
servicecontroller!DefaultDomain!1198!08/24/2018-15:19:17:: i INFO: RPC Server started. Endpoint name ='ReportingServices$PBIRS'
library!DefaultDomain!1be8!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
library!DefaultDomain!1be8!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
library!DefaultDomain!1be8!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
library!DefaultDomain!1be8!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

 

 

 

Anonymous
Not applicable

FYI: I had NO errors show up during the install or configuration of the Power BI Report Server (?)

It sounds like your configuration might be messed up, did you configure both the Portal and Report Server URLs in the configuration tool? If you did I would suggest removing the reservations and trying again.

Anonymous
Not applicable

We are now trying the August 2018 evaluation version and cannot install it.  Here are parts of the install log...

 

--

 

MSI (s) (20:F0) [08:58:40:600]: Doing action: RemoveExistingProducts
MSI (s) (20:F0) [08:58:40:600]: Note: 1: 2205 2:  3: ActionText
Action ended 8:58:40: InstallValidate. Return value 1.
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2205 2:  3: Error
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 22
Action start 8:58:40: RemoveExistingProducts.
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2205 2:  3: Error

 

--

 

MSI (s) (20:F0) [08:58:40:559]: Package name extracted from package path: 'PBIReportServerSetup.msi'
MSI (s) (20:F0) [08:58:40:559]: Package to be registered: 'PBIReportServerSetup.msi'
MSI (s) (20:F0) [08:58:40:559]: Note: 1: 2205 2:  3: Error
MSI (s) (20:F0) [08:58:40:560]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (20:F0) [08:58:40:560]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (20:F0) [08:58:40:560]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (20:F0) [08:58:40:560]: Product installation will be elevated because user is admin and product is being installed per-machine.

 

--

 

MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 23
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2205 2:  3: Error
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 16
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2205 2:  3: Error
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 21
MSI (s) (20:F0) [08:58:40:602]: Doing action: InstallInitialize
MSI (s) (20:F0) [08:58:40:602]: Note: 1: 2205 2:  3: ActionText
Action ended 8:58:40: RemoveExistingProducts. Return value 1.

 

--

 

Action start 8:58:41: InstallFiles.
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2205 2:  3: Patch
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2228 2:  3: Patch 4: SELECT `Patch`.`File_`, `Patch`.`Header`, `Patch`.`Attributes`, `Patch`.`Sequence`, `Patch`.`StreamRef_` FROM `Patch` WHERE `Patch`.`File_` = ? AND `Patch`.`#_MsiActive`=? ORDER BY `Patch`.`Sequence`
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2205 2:  3: Error
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1302
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2205 2:  3: MsiSFCBypass
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2228 2:  3: MsiSFCBypass 4: SELECT `File_` FROM `MsiSFCBypass` WHERE `File_` = ?
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2205 2:  3: MsiPatchHeaders
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2228 2:  3: MsiPatchHeaders 4: SELECT `Header` FROM `MsiPatchHeaders` WHERE `StreamRef` = ?

 

--

 

1|Setup FailedSystem.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin\ReportingServicesService.exe.config'.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)

 

--

 

We found a last minute issue that impacts clean installs, if you download the latest setup this issue has been fixed.

Anonymous
Not applicable

Thanks, Now I can re-install the report server, but still same old issue with not being able to upload .rdl (paginated) reporting services reports.

Anonymous
Not applicable

Do we also need to install Reporting Services on our Web Server?  Our environment is SQL Server 2012 on a separate DB Server and our Web Server (where we've installed Power BI Report Server) is running on Windows Server 2012 R2 Standard.  Any help is much appreciated, as our evaluation copy of Power BI Report Server is about to run out.  Thanks...

BrianG
New Member

Same condition, dont know whats wrong with this one. Help  needed.

Icloud Google Classroom GIMP

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.