Forum Discussion
Error: We couldn't connect to your DirectQuery data source
Hi septagon77 ,
After reading your description carefully, I think there may be an unexpected situation due to a connector issue.
As of the December 2019 release, NpgSQL 4.0.10 is provided with Power BI Desktop, so no additional installation is required. The GAC installation will replace the version supplied with Power BI Desktop, which is the default. Therefore, please try to download the latest version of power bi desktop and if it is already the latest version, try to uninstall and reinstall.
More detailed information can be found in the documentation:
Power Query PostgreSQL connector - Power Query | Microsoft Learn
Alternatively, you can try connecting to the PostGres database using dataflow. You can add and edit tables in the dataflow directly from the workspace where you created the dataflow and manage the data refresh schedule.
More details can be found in the documentation: Creating a dataflow - Power BI | Microsoft Learn
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Clara,
Maybe you did not read my explanation carefully enough. Of course, it is some kind of "unexpected situation due to a connector issue". That should have been obvious from my original post. I would not have needed to post my issue here if it was something simple like a uninstall/reinstall which I already have done multiple times.
It is clear that PowerBI can establish a temporary connection while it retreives metadata from the database to provide me a list of tables as well as a data preview. Quite quickly I might add. It is when PowerBI goes to establish this connection in the model that something goes wrong.
There is some kind of code collision either with one of the dll that is installed with PowerBI or one that already exists in the Win10 platform. I know this, because I have the same exact setup on a Win11 desktop, and it works.
Something happens after you hit the <Load> button and it goes to create the connection in the model. It does not instatiate the connection details properly. I have reviewed the four pages of stack trace and found nothing of use. I have turned on Enable Tracing and reviewed all the files in the Traces, Diagnostics, and Performance. Nothing that seems to be of use.
Dataflow is not an option that is available in the PowerBI version I am using. Using an ODBC connection has not worked either even though it works for Excel using Microsoft Query.