Native Snowflake Key Pair Authentication Fails via On-premises Data Gateway
We’re seeing an issue with the native Snowflake connection using Key Pair authentication through the On-premises Data Gateway. The same username and PKCS#8 private key work successfully with the Snowflake ODBC driver. However, when creating a managed connection using Connection Type: Snowflake and Authentication: Key Pair, it fails with: Unable to update connection credentials. Invalid connection credentials. Gateway logs only show a generic AccessUnauthorized / credential authentication error, and no authentication attempt reaches Snowflake. Has anyone experienced this with native Snowflake Key Pair authentication through the On-premises Data Gateway, or is there any additional gateway-side configuration required?
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}}}
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
GOING CRAZY! PUBLISHED MY REPORT, TRIED VIEWING, GETTING ERROR MESSAGE Data source unreachable
THIS IS JUST DRIVING ME CRAZY. CAN SOMEONE HELP? I created a power bi report on the desktop, published it... and this is what happens - See picture below. i tried setting up gateway... doesn't work.. all i want to do is view the report that i made.. .thats it... seriously.
