Unable to save report to PowerBI Report Server after enabling HTTPS / TLS
Hi All, After configuring my PowerBI Report Server to use a TLS Certificate I am unable to save save reports from PowerBI Desktop to the PowerBI Server. I have tried nemerous fixes from threads on this forum, but the error persists. Please see ItemNotFoundException towards the end of the "PowerBI Report Server Error" section below. PowerBI Desktop Error: Saving to PowerBI Report Server An error occured while attempting to save the report to PowerBI Report Server. PowerBI Report Server Error: 2023-08-11 07:37:37.7626|INFO|1|File Logger created: D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPortal_2023_08_11_07_37_37.log - level Info, will roll at 32 Mb, process id 6376 2023-08-11 07:37:37.7776|INFO|1|Provider name 2023-08-11 07:37:37.7776|INFO|1|Container name Microsoft SQL Server Reporting Services Key Container 2010 2023-08-11 07:37:37.7776|INFO|1|Setting Symmetric Key 2023-08-11 07:37:37.7938|INFO|1|Setting up Hosted Process State 2023-08-11 07:37:38.0123|INFO|1|library|SQLDump flags: ReferencedMemory, AllThreads, SendToWatson 2023-08-11 07:37:38.0123|INFO|1|library|MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData 2023-08-11 07:37:38.0123|INFO|1|library|Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExceptionMicrosoft.ReportingServices.Modeling.InternalModelingExceptionMicrosoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException 2023-08-11 07:37:38.0123|INFO|1|library|Do not dump on: Microsoft.PowerBI.ReportServer.WebApi.Catalog.CatalogAccessExceptionSystem.Threading.ThreadAbortExceptionSystem.Web.UI.ViewStateExceptionSystem.OutOfMemoryExceptionSystem.Web.HttpExceptionSystem.IO.IOExceptionSystem.IO.FileLoadExceptionMicrosoft.SharePoint.SPExceptionMicrosoft.ReportingServices.WmiProvider.WMIProviderExceptionSystem.AppDomainUnloadedException 2023-08-11 07:37:38.0123|INFO|1|library|Minidump location: C:\Users\PBIRS_SVC\AppData\Local\Temp\ 2023-08-11 07:37:38.0123|INFO|1|Starting ReportServerWebApp 2023-08-11 07:37:38.0279|INFO|1|library|Catalog max connection pool size: 768 2023-08-11 07:37:38.0592|INFO|1|Working directory : D:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal 2023-08-11 07:37:38.0592|INFO|1|Report Server url: https://powerbirs.domain.com/ReportServer 2023-08-11 07:37:38.0592|INFO|1|Report Server Web App virtual root: /Reports 2023-08-11 07:37:38.0592|INFO|1|Web app url: https://powerbirs.domain.com:443/Reports/ 2023-08-11 07:37:38.0592|INFO|1|Authentication scheme(s): IntegratedWindowsAuthentication 2023-08-11 07:37:38.1061|INFO|1|Catalog max connection pool size: 100 2023-08-11 07:37:39.1530|INFO|1|SecureConnectionLevel: 3. Redirecting HTTP connections to HTTPS. 2023-08-11 07:37:39.1842|INFO|1|crypto|Initializing crypto as user: DOMAIN\PBIRS_SVC 2023-08-11 07:37:39.1842|INFO|1|crypto|Exporting public key 2023-08-11 07:37:39.1998|INFO|1|crypto|Importing existing encryption key 2023-08-11 07:37:42.2780|INFO|4|<Header> <Product>Microsoft Power BI Report Server 1.17.8552.27722 (15.0.1112.48)</Product> <Locale>English (United States)</Locale> <TimeZone>UTC--7</TimeZone> <Path>D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPortal_2023_08_11_07_37_37.log</Path> <SystemName>SERVER-NAME</SystemName> <OSName>Microsoft Windows Server 2022 Standard Evaluation</OSName> <OSVersion>10.0.20348</OSVersion> <ProcessID>6376</ProcessID> <Virtualization>True</Virtualization> </Header> <ProcessorArchitecture>AMD64</ProcessorArchitecture> <ApplicationArchitecture>AMD64</ApplicationArchitecture> 2023-08-11 07:37:54.3873|INFO|7|Received request GET /api/v2.0/ServiceState| RequestID = s_94cef32e-9202-4680-8b64-a7b83ab3dac7 2023-08-11 07:37:54.6685|INFO|7|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.2801696| RequestID = s_94cef32e-9202-4680-8b64-a7b83ab3dac7 2023-08-11 07:37:54.8560|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/')| RequestID = s_4fd49dd9-9f8f-4890-a924-15e2c3b2bb27 2023-08-11 07:37:54.9498|INFO|7|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0996048| RequestID = s_4fd49dd9-9f8f-4890-a924-15e2c3b2bb27 2023-08-11 07:37:54.9658|INFO|7|Received request GET /api/v2.0/catalogitems(e9dc2b00-9e76-4468-ab07-f057a3c589dc)/Model.Folder/catalogitems/| RequestID = s_65b472da-ee59-4477-8fb4-de5e00f67bd4 2023-08-11 07:37:55.0436|INFO|7|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0817706| RequestID = s_65b472da-ee59-4477-8fb4-de5e00f67bd4 2023-08-11 07:37:56.6373|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/EDW')| RequestID = s_80135d36-17ab-40e2-b70f-8c5e372c6537 2023-08-11 07:37:56.6529|INFO|7|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0127266| RequestID = s_80135d36-17ab-40e2-b70f-8c5e372c6537 2023-08-11 07:37:56.6529|INFO|17|Received request GET /api/v2.0/catalogitems(2ba032b9-e3f4-4fe6-871d-ceff0af2b983)/Model.Folder/catalogitems/| RequestID = s_e3ec502c-526f-40e6-bab7-733843633eab 2023-08-11 07:37:56.6529|INFO|17|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0070938| RequestID = s_e3ec502c-526f-40e6-bab7-733843633eab 2023-08-11 07:38:02.5123|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/EDW/New_Report')| RequestID = s_b003b38d-5607-4d84-8661-6a422ee50bad 2023-08-11 07:38:02.5280|ERROR|7|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/EDW/New_Report' cannot be found.;| RequestID = s_b003b38d-5607-4d84-8661-6a422ee50bad 2023-08-11 07:38:02.5435|INFO|7|Sending response. Response code DOMAIN\User 404, Elapsed time 0:00:00.0192931| RequestID = s_b003b38d-5607-4d84-8661-6a422ee50bad 2023-08-11 07:38:03.1374|INFO|17|Received request GET /api/v2.0/System/Properties| RequestID = s_a839f6f6-68a9-4fee-ae70-903a96e6da91 2023-08-11 07:38:03.1685|INFO|17|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.022886| RequestID = s_a839f6f6-68a9-4fee-ae70-903a96e6da91 2023-08-11 07:38:03.2779|INFO|17|Received request GET /api/v2.0/me| RequestID = s_55924c0b-902a-4c97-a43a-9e6a3f9818ec 2023-08-11 07:38:03.2935|INFO|17|Catalog max connection pool size: 100| RequestID = s_55924c0b-902a-4c97-a43a-9e6a3f9818ec 2023-08-11 07:38:03.2935|INFO|17|Creating default Global MeterCollector| RequestID = s_55924c0b-902a-4c97-a43a-9e6a3f9818ec 2023-08-11 07:38:03.3560|INFO|17|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0758321| RequestID = s_55924c0b-902a-4c97-a43a-9e6a3f9818ec 2023-08-11 07:38:03.3560|INFO|17|Received request POST /api/v2.0/powerbireports(Path='/EDW/New_Report')/Model.Upload| RequestID = s_cd1ccc82-2e3e-4ee8-bd9b-b9eb4907a6c0 2023-08-11 07:38:03.3717|ERROR|17|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/EDW/New_Report' cannot be found.;| RequestID = s_cd1ccc82-2e3e-4ee8-bd9b-b9eb4907a6c0 2023-08-11 07:38:03.4810|ERROR|6|The remote server returned an error: (503) Server Unavailable.| RequestID = s_cd1ccc82-2e3e-4ee8-bd9b-b9eb4907a6c0 2023-08-11 07:38:03.4810|INFO|11|Sending response. Response code DOMAIN\User 422, Elapsed time 0:00:00.1222532| RequestID = s_cd1ccc82-2e3e-4ee8-bd9b-b9eb4907a6c0 Thank you Stephan
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Hello! When I update my PBI file on browser it returns me this error: Codice errore sottostante-2147467259 Messaggio di errore sottostanteMicrosoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read 'Azienda.Mdb'. To download the client software, visit the following site: DM_ErrorDetailNameCode_UnderlyingHResult-2147467259 Microsoft.Data.Mashup.ValueError.ReasonDataSource.NotFound URI clusterWABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net ID attività f0996aca-4148-41f6-87d0-0ad19591125e ID richiesta7ed0bdce-816a-1171-5b15-1da65c837443 Ora2022-09-15 10:57:58Z So, i have installed on my server wiht Windows Server 2019, Office 2013 32bit, Power Bi Desktop 32bit and Personal Gateway. PBI file has two soruces: a excel file and an access file (.Mdb) Readgin online, i installed Microsoft Access Database Engine 2010 Redistributable but erros doesnt fix. How can i do? Thank you
Power BI Report Server Licence Cost / Import datasets limit
I am planning to work on PowerBI Project. I have a client requirement to depoy PowerBI reports on premise SQL Server Report Server. I know that we can get the PowerBI Report Server Licence by using one of the following ways Power BI Premium (PowerBI Service) SQL Server Enterprise Edition with Software Assurance (SA) It would be very helpful for me if any one can suggest / provide the solution on my below queries Query1 In SQL Server Report Server, we can import 2 GB of data. Is there any way to import more than 2 GB data in SQL Server Report Server? I have approx 8 to 10 GB data to import. Query2 Can we get the same P SKUs licence for PowerBI Report Server using SQL Server Enterprise Edition with Software Assurance (SA) as we can get Power BI Premium to deploy reports on PowerBI Service? e.g can get P1 (8 Core) or P2 (16 Core) or P3 (32 Core)...licence for PowerBI Report Server If yes then what would be import limit in PowerBI Report Server for P1, P2, P3.... Many Thanks in Advance.. Really great if any one can resolve these queriesparameters in report server
I made a reprot in powerbi desktop (RS) with a dataset which is a query on SQL DB. I have a list of parameters to pass to the report. I can do this in desktop by selecting the parameters, but when I publish to the Report server, I can't select any parameters. How can I give the possibility to my end-users to select parameters on the report server? (I want the exact parameter functionality of SSRS)
Refresh dataset automatically when we change any records from the dataset in power bi .
is there any way to dynamically update data in Power Bi report when we change any field of CRM Entity? when we use refresh button it will not reflect that updated data.One way to schedule refresh but requirement is to instantly reflect the updated data In schedule refresh. the data automatically refresh on that schedule time. but it will not trigger when data gets change . It will trigger in its schedule time