postgres

3 Topics

Error while connecting PostGres to Power BI
I'm trying to connect my Power BI Desktop to Post Gres SQL. I get the following error when I tried to connect. Details: "Loading assembly file 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'PostgreSQL'" With the same credentials, im able to connect to the MY SQL workbench
Solved
Gandhar09
2 years ago Place Report Server
Views
0likes
Comments
Can't connect to DB Azure Postgres
Hello! I have a problem with connect to my Azure Postgres. When I try connect to DB I see error: "Не удалось обновить учетные данные источников данных: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.'" Also, some information. I have already managed to connect this Database to another PowerBi account. The database and that old account were registered on the same organization domain. I thought that this might be the case and tried to create a new database on the domain where I have now created a new PowerBI account, however I am seeing the exact same error. Help me, please!
badkor3434
2 years ago Place Report Server
Views
0likes
Comments
Error connecting Postgres with Gateway
I can connect Power BI Desktop to a local Postgres server, so I published a Power BI report and tried to set up a connection on Power BI Cloud with my local gateway that can access Postgres. If I try to update the semantic model, I receive this error: Errore dell'origine dati: [ValidateMarkupTags]{"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":"[ccon]Installare Npgsql versione 4.0.16.0</ip> o precedente.[/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10305"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"PostgreSQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"[ccon][ccon]<ip>192.168.0.12</ip>[/ccon]<ip><ip>192.168.0.0</ip></ip>;val_fKOANemvfL[/ccon]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.MissingClientLibrary"}}],"exceptionCulprit":1}}} Table: prodotto. URI cluster: WABI-WEST-EUROPE-redirect.analysis.windows.net ID attività: 7a39cf9b-0094-4de7-be3f-2c8be3c19cdc ID richiesta: 4d229eaa-5fba-68b3-b18c-ab4637ad8aa5 Ora: 2024-12-20 10:32:25Z I've installed Npgsql version 4.0.16.0 as stated in the error log and restarted the gateway, but I still get the same error. My gateway is okay because I use it to access Excel files that are on the local network in other Power BI reports. Sorry if my English is not correct.
Solved
rinogattuso
1 year ago Place Report Server
Views
0likes
Comments