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?
Report Builder subscriptions - Failure writing file
Hello Everyone, In our company we are using Report Builder to create report that its subscrubied to others as an Excel file. We are having problem when trying to run the subscription. Here is the error: And here is the configuration: The user that created the subscription is the same as the one that will save the file in shared location. Its an admin user so it has access to the folder and of course it has access to write data in the folder. Shared location is on the localhost where the Report Server is installed. The user is also an Active DIrectory User not local server user. When trying to run the subscripition we can see that in the mentioned error PBRS does not mention any user in the quote sings. Do we need to set up some more priviliges for this user? If yes then where? Is there a place where we can see more logs about this error? I hope someone will help us with this problem 🙂 Greetings to you all.
Refresh Failure - Invalid Connection Credentials
Two of my larger datasets are all of a sudden failing to refresh via the automatic refresh schedule on the service. The top line of the email failure message states "Invalid Connection Credentials" however, the detail of the email message states "internal service error/transient issue". Where should I start to diagnois this problem? When I originally published this data set and scheduled the refresh, I was not having this issue. Thank you! Invalid connection credentials. Refresh failed: xxxxxxxxxxx has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. Next refresh for xxxxxxxxxxxxxxx is scheduled for August 26, 2020 11:00 UTC.
Power BI On-premises data gateway install failed
Good Morning, tried several time to upgrade my On-premises data gateway to last version, but installation fails: <...> MSI (s) (1C:F0) [17:30:00:337]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI6952.tmp, Entrypoint: RegisterPerfCounterData RegisterPerfCounterData: Error 0x800703f2: Failed to execute install of performance counter category: On-premises data gateway RegisterPerfCounterData: Error 0x800703f2: Failed to execute PerformanceCategory table. MSI (s) (1C!CC) [17:30:00:823]: Product: GatewayComponents -- Error 26253. Failed to install performance counters. (-2147023886 ) Error 26253. Failed to install performance counters. (-2147023886 ) CustomAction RegisterPerfCounterData returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) MSI (s) (1C:04) [17:30:00:847]: Note: 1: 2265 2: 3: -2147287035 MSI (s) (1C:04) [17:30:00:847]: User policy value 'DisableRollback' is 0 MSI (s) (1C:04) [17:30:00:847]: Machine policy value 'DisableRollback' is 0 Action ended 17:30:00: InstallFinalize. Return value 3. MSI (s) (1C:04) [17:30:00:849]: Note: 1: 2318 2: <...> Any ideas on what to check? Thanks in advance. Paolo.
