GWPipeline_Gateway_DataSourceAccessError"
Dear Memebers, I am new to the Fabric community and would need your advise on the below issue: User has created the paginated report and published to the Premium workspace.When trying to run the report he is getting error below: Unable to render paginated report There was an error communicating with Analysis Services.Please verify the data source is available and your credentials are correct.{"error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","parameters":{},"details":[],"exceptionCulprit":1}}}
Can't connect to Oracle 19 through on prem gateway
We have the 3000.89.6 version of the on prem gateway and are trying to connect to oracle using the 64bit 19.3 ODAC and get the following message when trying to add the datasource. The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' We have followed the instructions in the git at Oracle ODAC 18 is supported with additional steps · Issue #2147 · MicrosoftDocs/powerbi-docs · GitHub and made sure there was no space between the colon in the .NET version. Any help would be appreciated. We are able to successfully connect from Power BI Desktop installed on the gateway server. The OS is x64, the gateway services should be x64 as well, correct?
Unable to load Oracle data to a paginated report - failed to create windows identity for user
I have a paginated report that loads data from an Oracle DB. It works fine on the Report Builder app on my desktop, but when run in the service it returns the following error. The data source works fine for Power BI reports; paginated reports that use SQL Server data work perfectly, so it appears to be something on the gateway retrieving data for Report Server ? Could not connect to the data source. A data source used by this report returned an error. If you continue to experience this error contract the report author or data source owner quoting: DM_GWPipelineGatewayImpersonationError. Failed to create windows identity for user [email protected]
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
Error while refreshing through gateway
Hi I'm getting this error massage everytime I refresh through the gateway. Refreshing using PBI Desktop is working fine... We noticed that these errors are on tables that contain a 'Merged Queries' as a step on the APPLIED STEPS on PBI, and when we removed these steps it started to complete the refresh through the gateway. Any idea on what can be done to solve it? Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"MySQL: Fatal error encountered during data read."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"server"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Fatal error encountered during data read."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Daily Business Monitoring. Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net Activity ID: 00000000-0000-0000-0000-000000000000 Request ID: 9df8fd52-4f93-4f34-9cb2-b75f10d4ed7c Time: 2022-07-05 04:50:42Z