cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pavkanna Frequent Visitor
Frequent Visitor

UNABLE TO LOAD DATA - ODBC

Hello,

I am able to establish the ODBC connection to the DB using a Postgres ODBC driver. I am using the desktop latest version of Power BI. I can see the tables available, but when I try to load the data, I encounter the following error.

 

DataSource.Error: ODBC: ERROR [HY000] Error while executing the query
Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=ParstreamUser
    OdbcErrors=Table

 

I can however use the connection string, and get an SQL statement to work. I am assuming its some parsing issue.

Any help is highly appreciated!

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: UNABLE TO LOAD DATA - ODBC

@Pavkanna,

What version of Power BI Desktop do you use? Do you use 32 bit or 64bit Power BI Desktop? Also please check if you can connect to the ODBC data source from other application such as Excel.


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Pavkanna Frequent Visitor
Frequent Visitor

Re: UNABLE TO LOAD DATA - ODBC

@v-yuezhe-msft,

 

Version: 2.56.5023.1021 64-bit (March 2018)

There is only one ODBC driver that I can use to connect to parstream. And Yes, I can connect to the data source from other application.

 

Thank you.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 1,028 guests
Please welcome our newest community members: