cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rwells7722
New Member

Can connect to ODBC data with Excel but not with Power BI

I'm a new user.

I have a database with many tables. The database is created and updated with Clarion Topspped. I can easily read and create reports in Excel using an ODBC driver that has been installed on my Windows machine. I can also get data using Access. But the same workbook can't find the tables with Power Pivot, even though it says that the connection was successful, and Power BI Desktop won't connect at all (perhaps because it is trying to write to the database). It is very frustrating to be able to connect easily with Excel and Access and to be completely stymied by Power Pivot and Power BI Desktop. Surely this is not a new phenomenon, but I"m not seeing others with the same question, so maybe I'm just asking wrong.

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: Can connect to ODBC data with Excel but not with Power BI

@rwells7722,

Do you create dsn for the Clarion Topspped data source with the help of ODBC driver ? If you have created the dsn, you can use ODBC connector in Power BI Desktop to connect to it and import data from required tables.

1.PNG

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.
farlesh1000
Regular Visitor

Re: Can connect to ODBC data with Excel but not with Power BI

Was this ever answered?  The response is irrelvant.  The ODBC driver that works with Excel (we have OpenEdge 11.3 ODBC Driver) does not load table schema.  Just simply using the query editor sounds like all kinds of fun except table joins aren't working too well in the query editor and joins with filters aren't working well either.  Power BI Get Data ETL is not loading table schema like it's supposed to.  The question is a year old, how can this not be answered yet?

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors