Report Server does not complete Data Refresh
Hi all, I have the following issue several days ago. When I publish a new report or re-configure the Screduled Refresh for old reports, the Status of Scheduler stucks in "Updating" Status. But the old reports that run and were scheduled 1 month before (without touching them) are working properly (they finish the scheduler correctly). Here some information of my environment: If need some additional information please just let me know. Thanks. Oscar.Publish to Power BI - Report contains unsupported data source SHAREPOINTLIST
Hi We have 1200+ RDL's in SSRS 2016 that need to be migrated to the Power BI Service. Many have just SQL data sources but hundreds of them also have a "Microsoft Sharepoint List" data type as part of the RDL I have moved a test group to a SSRS 2022 Power BI Report Server instance, so I can use to the Publish to Power BI feature. Reports without Sharepoint data sources seem to publish flawlessly. I get "Report contains unsupported data source SHAREPOINTLIST" for any with Sharepoint lists. It seems I can setup on prem and cloud Sharepoint connections in power bi service but is there no way to get my RDL's to use them? Either before or after migrating? Or am I doing something wrong If it helps or hurts my situation.. the other moving target is we are migrating from on-prem sharepoint to Sharepoint online, at the same time as this Power bi migration. Any advice for our scenario would be great! We are trying to avoid re-building hundreds of reports. Thanks, Dave
Link a PBI table in sharepoint with interactions
Hello, I am facing a problem I would like to link this table to a sharepoint group allowing to modify all these anomalies. It would be necessary to add a column "Treated", once checked the anomaly is removed. I had the idea to link this table with the "List" tool but it is not possible. The objective is to create an interactive tool allowing everyone to interact. If not through this table it would be possible from my PBI database. Thank you for helpPBI reporting server-Maria DB-direct query
I'm tryng to do direct query to mariadb in PBI desktop and it just works fine. However whenever i move the report to reporting server, it just doesnt work. following is the error I get when i try to run the report via browser - An unexpected error occurred An unexpected error occurred. Please try again later. Please try again later or contact support. If you contact support, please provide these details. We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.: Request ID: bcac8abc-c1c8-e4be-63b3-f9ad8349d434 Time: Wed Jan 05 2022 12:39:24 GMT-0500 (Eastern Standard Time) Service version: /powerbi/libs I looked at different error logs and ng is what i could see - 1. message in RSPortal. Error message shown here has something to do with access. However the user mentioned is my id in the desktop where i created this PBI report. Why would reporting server complain saying my personal account (US\AF12345) has some access issues; whereas reporting server is supposed to run under PBIRS service account.. Am I missing somehting here? 2022-01-05 12:39:24.2109|ERROR|135|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.WindowsAuthz5ApiException: , Microsoft.ReportingServices.Diagnostics.Utilities.WindowsAuthz5ApiException: Windows returned a ERROR_ACCESS_DENIED error when Reporting Services attempted to call the Windows Authz APIs. If this issue persists the Reporting Services account may not possess permission to perform authentication checks. Check the Windows Authz documentation for more information and details on diagnosing issues. Authz method: AuthzInitializeContextFromSid, Error code: 5, UserName: US\AF12345;| RequestID = bcac8abc-c1c8-e4be-63b3-f9ad8349d434 ClientSessionID = a6bb8265-4c27-15d1-0a04-0d3fba5247f8 2022-01-05 12:39:24.2109|INFO|135|library|Unable to authenticate US\AF12345 by alias. The Windows domain controller may be unavailable - attempting to authenticate using UserToken.| RequestID = bcac8abc-c1c8-e4be-63b3-f9ad8349d434 ClientSessionID = a6bb8265-4c27-15d1-0a04-0d3fba5247f8 2. ASManaged root log - it says datasource is unknown!! 2022-01-05 11:47:11.7300|INFO|66|GetV3ConnectionString Called - Engine connection string: Provider=Microsoft.PowerBI.OleDb;Mashup=UEsDBBQAAgAIAORdJVQ+Tv++xwAAACMBAAATABwARm9ybXVsYXMvU2bUCkAAAA6QAAABMAAAAAAAAAAAAAAAAA/QEAAFtDb250ZW50X1R5cGVzXS54bWxQSwUGAAAAAAMAAwDCAAAA7gIAAAAA; User principal name: [email protected]; dataSourceIds: {"protocol":"x-datasource","address":{"kind":"UnknownFunction","path":"UnknownFunction"}}; Root activity ID: e114d109-6fca-433a-9c75-64ac9a8d2b54. 2022-01-05 11:47:11.7300|ERROR|66|GetV3ConnectionString - Exception occured while retrieving credentials for data model connection string.System.NotSupportedException: The given data source kind is not supported. Data source kind: UnknownFunction. at Microsoft.Data.Mashup.DataSourceReference..ctor(String json) at Microsoft.PowerBI.ReportServer.ASEngineManagedRoot.PBIRSConnectionDetailsProvider.GetPathFromDSR(String dsrJson) at System.Linq.Enumerable.<>c__DisplayClass7_0`3.<CombineSelectors>b__0(TSource x) at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext() at System.Linq.Enumerable.<SelectManyIterator>d__17`2.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at Microsoft.PowerBI.ReportServer.ASEngineManagedRoot.PBIRSConnectionDetailsProvider.GetDatasources(String userPrincipalName, String[] datasourceIds, Guid rootActivityId) at Microsoft.PowerBI.ReportServer.ASEngineManagedRoot.PBIRSConnectionDetailsProvider.GetV3ConnectionString(Guid rootActivityId, String userPrincipalName, String engineConnectionString, String[] datasourceIds, String contextualIdentity, String contextualIdentityKey, Boolean isDirectQueryExecution, PBIDedicatedProviderType& providerType, String& connectionString) I'm really stuck and appreciate if ayonbe could help me here..List of power BI reports connected to ssas tabular model
Hi all, Someone knows, where I can get a list of power BI reports connected to ssas tabular models. In some PBI database. the situation is I need to make a migration from ver 2012 databases, to v2016 and I need to check witch SSAS db is connected to witch PBI reports, to test them, if everything runs perfectly. Thanks
PBI RS (May 2021) report URLs changing or changed & Email subscription links (paginated reports)
I had a user point out that the url link that PBI RS inserts at the bottom of an email body does not take them to the report, but rather a variation of the reports' url resulting in a "Not Found HTTP Error 404. The requested resource is not found." error. In looking at the issue closer I found that after upgrading report server to May 2021 version that report urls are changing when the report is accessed. Once the report is accessed by a user, the reports' url is getting "/report/" added to the url. This is where the "Include Link" function for paginated report subscriptions breaks for users. This is new behavior to me, I need to resolve it. Please help.
