Trouble with PostgreSQL query from Desktop to Web
Hi everyone, I'm having some issues with my PostgreSQL connector. I recently created a database and tables in PostgreSQL, and I've successfully was able to get it to connect to Power BI using a PostgreSQL connector, desktop version. However, as soon as I try to use it online/web, I'm trying to use a Cloud Connection and I get this error, no matter what: Unable to update connection credentials. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue Details: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)' Please have this information handy if you choose to create a support ticket. ActivityId: 7f515ef6-8778-4665-9abb-ac90534e70da RequestId: a69bc790-4ffa-4900-99a7-980dfab69e85 Cluster URI: https://api.powerbi.com Status code: 400 Time: Sun Sep 10 2023 16:22:48 GMT-0600 (Mountain Daylight Time) I'm not a pro by any means, but I can't figure it out. Any help or guidance is appreciated. Again, no problem accessing my Server and DB from other places including Desktop Power BI, just Web version (app.powerbi.com). Thanks
Power BI refresh fails 90% of the time with postgres ODBC
We are having refresh errors 90% of the time for our reports. Repeatedly refreshing it manually might solve the problem. There are no problems refreshing via powerbi desktop app on the report server. Driver={PostgreSQL ANSI(x64)}; Server=xx.xx.xx.xx; Port=5432; Database=xxx; Connection Timeout=500; SessionID: 0622896a-4188-495f-9aef-57291a069a69 [0] -1055784932: The 'Driver' property with value '{PostgreSQL ANSI(x64)}' doesn't correspond to an installed ODBC driver.. The exception was raised by the IDbCommand interface. [1] -1055129594: The current operation was cancelled because another operation in the transaction failed. [2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.PostgreSQL- Publish Error
I'm having an issue around published dashboard that connect to PostgreSQL that do not work. From my Power BI desktop, I can connect to PostgreSQL and build a (direct query) viz with no issues. I can even publish and get the "success" window. However, when I go to view the published dashboard, I get an access error about credentials. I have not modified anything on the PostgreSQL/ AWS side, but I'm wondering if there is something outside of Power BI that needs to be modified (maybe ralated to SSL)? Thank you. Thank you in advanced
Cannot connect on-premise gateway with postgres on PowerBI
With powerbi desktop I can easily connect with postgres database on server(192.168.1.5:32100) running on a port and a database_name. But doing the same with PowerBI on premise gateway I could not connect when adding a data source on gateway setting(gateway cluster). Below screenshot for reference. The first picture is of PowerBI desktop and the second one is on gateway settings. Is it something with the port?If yes I was able to connect on PowerBI desktop, if no then is there any way or am I missing something. Thanks in advance for the help.
Connecting to Postgres in Report Builder
Hi, I'm trying to connect to a postgres data source through Power BI Report Builder - I assumed that I would have access to an ODBC data source setup, as per SSRS. Is this available in Power BI Report Builder or is there some kind of work around to allow me to connect to Postgres. The ODBC source is configured correctly in the Windows ODBC data sources The connection works in Power BI desktop using the Postgres data source option, however I now need to start building out some static reports using Report Builder Thank you
