Scheduled Refresh Plan for Power BI Server connected to Maria DB
Hi all, we are working on a Report on Power BI Server connected to a MariaDB database through the ODBC Connector (as described on their website) as "Import" (not Direct Query). We cannot setup the Scheduled Refresh Plan, it seems impossible to setup under these conditions. IT is shown the following error under the "Scheduling Update" tab it gives the following error: "Planned data update is not available for reports. The report does not contain defined external data connections or uses an unsupported data source" Do anyone have a solution for this issue? Many thanks, A
Direct Query MariaDb not working in Power Bi Online
Hi! I currently am using Direct Query with MariaDb and on the Desktop version everything is working fine, but when publish the report to the online environment i get the following error message and all the visuals are white. Cannot load the model Cannot load the model schema associated with this report. Check that the server connection is active and try again. Check the technical details for more information. When contacting support, provide these details. Does anyone may know what is causing this problem? Thanks in advance - WillemDirect Query Power Bi online service
Hey all! I have a problem what is somewhat still unclear for me; i am using MariaDb with a direct query connection on Power Bi Desktop and everything is working fine. when i want to Publish the file to the Power Bi online service, all the visuals online are just white and i get the following error message: ____ Cannot load the model Cannot load the model schema associated with this report. Check that the server connection is active and try again. Check the technical details for more information. When contacting support, provide these details. Onderliggende fout: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DatasourceAnalysisFailedWithUnknownFunctions Activiteits-id: 5d9cae4d-6646-4f80-95e9-1743b834869d Correlatie-id: 7d57e84e-f3d7-7030-4fc6-e2bc6db8494c Aanvraag-id: 11dcd3a4-9bed-6ffb-bae6-1ba3894a5cab Tijd: Wed Aug 10 2022 10:01:00 GMT+0200 (Midden-Europese zomertijd) Serviceversie: 13.0.18800.35 Versie van client: 2208.1.12628-train URI cluster: https://wabi-west-europe-e-primary-redirect.analysis.windows.net/ Has anyone have a solution to have a Direct Query connection with MariaDb?? Thank in advance - Willem
PBI 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..
