Lookup error for session ID using report server DB or API
Hi, We are using SSRS APIs to create refresh plan schedule for PBIX report on PBI report server. And we get the last run status but it does not return details. Data Refresh failed, contact the administrator, SessionId: dd13d7bf-56ef-4eed-865a-de6f67d3a50e. We do have the session ID and if we search for it in report server logs then we find the details. Also we can see details if we go to refresh plan details on report server UI. Details in SSRS log: Data Refresh failed, contact the administrator, SessionId: dd13d7bf-56ef-4eed-865a-de6f67d3a50e. Details in refresh plan UI: But we want to show this info on our web application. We already tried searching report server DB (tables, executionlog views, etc) for these details but did not find any thing. Where can we find these information/details other than reporting services logs? Any API or DB table?
Cannot Render PBIX reports - Get An Error has occurred.
Today we have been getting the generic error - "An error has occurred" when trying to render reports on power bi server. I looked at the log files and I see a lot of "ERROR 53 OData exception occurred: System.Net.WebException: The remote server returned an error: (401) Unauthorized." I have done a lot of research but I haven't seen anything that can help me. Any help would be much appreciCannot upload PBIX file on fresh install of PBIRS
Hi, we recently aquired a separate testing environment for our project, so we installed a new VM with SQL Server 2017 (same as production) but as developer edition (not sure if relevant). On it we installed Power BI Report Server 15.0.1103.232 x64. We configured a service account from our domain, configured the web service url and database. The portal works fine, but as soon as we tried to upload our pbix files from the other environment or even simple dummy files we always get the same error: (translated) Error uploading the PBIX file. Check if the file is damaged and if the extension matches the content of the file. (german original) Fehler beim Hochladen Ihrer PBIX-Datei. Überprüfen Sie, ob die Datei beschädigt ist, und stellen Sie sicher, dass die Dateierweiterung dem Format der Datei entspricht. If I check the browser developer tools I see that a request to a service fails with HTTP 422 (Unprocessable Entity) Name Protocol Method Result Content type Received Time Initiator http://[servername removed]/reports/api/v2.0/catalogitems HTTP POST 422 application/json 235 B 55,55 ms The same happens if I try to upload through Power BI Desktop (the Report Server Version 2.81.5831.1181 x64, as downloaded from the portal-site) but with different error message: An error occured while attempting to save the report to Power BI Report Server. The Portal-Logfile shows a "forbidden" error: 2020-09-11 13:16:36.3110|INFO|64|Received request GET /api/v2.0/System/Properties| RequestID = s_539fdc5e-b610-4eb4-82d8-1229ee540610 2020-09-11 13:16:36.3110|INFO|64|Sending response. Response code [removed user name] 200, Elapsed time 0:00:00.0063115| RequestID = s_539fdc5e-b610-4eb4-82d8-1229ee540610 2020-09-11 13:16:36.6408|INFO|64|Received request GET /api/v2.0/me| RequestID = s_0e1e4a8d-f940-4dcb-8997-17eb4cbe2d9a 2020-09-11 13:16:36.6720|INFO|64|Sending response. Response code [removed user name] 200, Elapsed time 0:00:00.0289183| RequestID = s_0e1e4a8d-f940-4dcb-8997-17eb4cbe2d9a 2020-09-11 13:16:36.7502|INFO|64|Received request POST /api/v2.0/powerbireports(Path='/sample')/Model.Upload| RequestID = s_a1f0ea50-22a6-4ee7-b109-918fd408f22c 2020-09-11 13:16:36.8127|ERROR|65|The remote server returned an error: (403) Forbidden.| RequestID = s_a1f0ea50-22a6-4ee7-b109-918fd408f22c 2020-09-11 13:16:36.8127|INFO|67|Sending response. Response code [removed user name] 422, Elapsed time 0:00:00.0611536| RequestID = s_a1f0ea50-22a6-4ee7-b109-918fd408f22c I know there are numerous reports to the same error, but all suggested solutions did not work and most were for older versions and I often read that the compatibility between versions is an issue, so I don't know how relevant these are to the current may 2020 version. I restarted the service (and reinstalled the reportserver including deleting report databases) multiple times. I use a domain account as service-account. I even tried granting it local admin privileges (testing environment, so...) The portal runs (by now) without https, so it should not be certificate stuff... The test files are small (<1mb) and can be uploaded to our production server just fine. The command "netsh http show urlacl" shows my site registration correctly. I am really out of ideas what I can do and "msdn subscriber" support pointed me here... I hope anyone of you does 😄 Best regards Sebastian
