Error: We couldn't connect to your DirectQuery data source

Question

I am connecting to a PostGres database through a Transport connection.&nbsp; I am able to connect to the server and see the tables in the database.&nbsp; I am able to select a table and see a preview of the data.&nbsp; I am using a DirectQuery connection.&nbsp; Once I hit the load button to bring the table into PowerBI I receive the above error.&nbsp; I am able to see the table in the Model View but not the Report View.&nbsp; Any action that works with the model throws the same error again.&nbsp; Any ideas as to the cause of the error?

anonymous · Answer

Hi&nbsp;septagon77&nbsp;,
&nbsp;
Double-check that your server and database names are correct and that you have access to them.
1. Check that all data models have been imported into Power BI. If there is a Direct Query data model in the report, the local computer should have access to the data source.
2. Try opening a new powerbi desktop and clearing the data source permissions.

&nbsp;

&nbsp;
Then, reopen and reconfigure your pbix file. Ensure that your local machine has access to your data source.
&nbsp;
If your Current Period does not refer to this, please clarify in a follow-up reply.
&nbsp;
Best Regards,
Clara Gong
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;to help the other members find it more quickly.

septagon77 · Answer

Clara,&nbsp;Thank you for the reply, but perhaps you did not understand the problem.&nbsp; The database credentials are correct and my desktop can access the data source.&nbsp; I cannot interact with any tables imported into the model without throwing an error.&nbsp; As a result no objects from the Model view are available to use in the Report view therefore I cannot build a report.&nbsp; I have tried both options of Import or DirectQuery.&nbsp; Both fail.&nbsp;

anonymous · Answer

Hi&nbsp;septagon77&nbsp;,
&nbsp;
the PostgresSQL connector doesn't work out of the box, you need to do quite a few things first
&nbsp;
1. Install Npgsql which allows .NET access to PostgresSQL. It can be installed using the Pakagae Administrator Console in Visual Studio; detailed instructions are here:&nbsp;https://www.nuget.org/packages/Npgsql/
&nbsp;
You need to connect over SSL to AWS which isn't setup by default (on my Windows 10 machine anway)
&nbsp;
2. Download the AWS public key from here&nbsp;https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem
&nbsp;
3. Convert that&nbsp;to a certificate using&nbsp;https://www.sslshopper.com/ssl-converter.html&nbsp;(convert to PKCS#7/P7B)
&nbsp;
4. Import that certificate to the Trusted Room Certificate described here&nbsp;http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm
&nbsp;
Finally, you can try setting up an ODBC connection.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-Connect-to-an-ODBC-Data-Source-From-Power-BI/ba-p/960701
&nbsp;
&nbsp;
Best Regards,
Clara Gong
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;to help the other members find it more quickly.

septagon77 · Answer

Clara,&nbsp;None of that information you have provided is useful.&nbsp; I shall go through the issue in greater detail.I am running Power BI on a Win10 Pro version 22H2.&nbsp; I am connecting to a PostGres v 12.17 Database through a Teleport v 15.4.4 connection.&nbsp; I am able to connect to this data source using tools like DBeaver run queries successfully.&nbsp; This confims the connection to the data source is valid.I can launch Power BI and create a connection to the same PostGres data source using the PostGres Database connector.&nbsp; I am able to enter the server and database information which then brings me to the Navigator dialog box.&nbsp; On the left hand side I am able to see the server and all the tables available to me.&nbsp; If I mouse-click on a table I am able to see a data preview in the right hand side of the Navigator dialog box.&nbsp; I select a table and hit the &lt;Load&gt; button in the lower right hand corner.Once I hit the button I see the Create Connection Message box.&nbsp; As soon as the Create Connection Box disappears another Message box appears stating:&nbsp;Something went wrong&nbsp;We couldn't connect to your DirectQuery data source or internal model. Double-check that your server and database names are correct, and that you have permission to access them.&nbsp;Inside PowerBI in the Report View the Data blade on the far right side contains no objects, but if you switch to the Model view the table that was selected is visible.&nbsp; You can even do Edit Query and see the data in the table in the Power Query Editor.&nbsp; You can modify the query but when you hit "Close &amp; Apply" PowerBI throws the same error again.&nbsp;In summary, PowerBI is able to make a connection pull the meta data for the available tables and show previews of the data in the tables.&nbsp; There has to be a final handshake between PowerBI and the data source that would allow the Model to be made available in the Report View.&nbsp; This is where the error occurs.

anonymous · Answer

Hi&nbsp;septagon77&nbsp;,
&nbsp;
After reading your description carefully, I think there may be an unexpected situation due to a connector issue.
&nbsp;
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
&nbsp;
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

&nbsp;
&nbsp;
Best Regards,
Clara Gong
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;to help the other members find it more quickly.

Forum Discussion

Error: We couldn't connect to your DirectQuery data source

6 Replies

Related content

A DirectQuery connection is required error

DirectQuery Semantic Model

Connection failed using a Folder connection in a pipeline

Power BI Oracle Connection Error – ORA-50201 (Failed to connect / parse connect string)

connection to dataflows