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

ODBC Connection Error - Driver Error

Capture.PNGTrying to pull data and this message comes up. Any idea how I can get around it?

5 REPLIES 5
Moderator v-yuezhe-msft
Moderator

Re: ODBC Connection Error - Driver Error

@Rick93,

What data source do you create ODBC dsn for?

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.
Rick93 Frequent Visitor
Frequent Visitor

Re: ODBC Connection Error - Driver Error

I honestly have no idea - this is a corporate PC if that helps at all.

 

When trying to extract the data on to Excel I am going to:

 

Data

Get data

From other sources

ODBC

Kopen (the programme we use).

 

It's when I select one of the options listed below that it fails to work.

 

Moderator v-yuezhe-msft
Moderator

Re: ODBC Connection Error - Driver Error

@Rick93,

Do you create dsn for Kopen ? Have you tried the ODBC connector in Power BI Desktop?

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.
Rick93 Frequent Visitor
Frequent Visitor

Re: ODBC Connection Error - Driver Error

I'm trying this in Power BI Desktop.

 

I'm going to get data

- Other

- ODBC

- KOPEN

- Once I choose any option, this warning comes up

 

Capture2.PNG

 

Moderator v-yuezhe-msft
Moderator

Re: ODBC Connection Error - Driver Error

@Rick93,

Do you create a dsn named KOPEN? What is the original data source in the dsn?

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.

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: 282 members 2,757 guests
Please welcome our newest community members: