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

problem with query and ODBC

Hello,

 

I have a new problem but don't know if this because I updated my PowerBI or if this is because I have a new PC.

 

Until now, I could use as a data source a query in MS Access that was linked to an ODBC Table.

 

Now, I have an error message when I try that : Erreur OLE DB ou ODBC : [DataFormat.Error] ODBC--connection to 'KPI' failed..

 

It's possible to do a query that create a table and then link to the table. But I'm using data that are quiete huge. Thus, the query llinked to the ODBC has the advantage to be :

- more easy (no need to update the local tables every time)

- no needing to compact very frequently the MS Access because to huge

 

Anyone knows if this intentionnally from MS to block this type of connection ? Or if this purely local ?

 

Thank you for your help

4 REPLIES 4
Community Support Team
Community Support Team

Re: problem with query and ODBC

Hi @Brusselaar ,

Do you try to connect MS Access directly? Do it load the values normally? Maybe you could try to clear the global permission and re-connect it with ODBC to check if it works.

8.PNG9.PNG

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

Brusselaar Frequent Visitor
Frequent Visitor

Re: problem with query and ODBC

I can't clear permissions because it doesn't accept the data source

 

I will try a beter explanation

Brusselaar Frequent Visitor
Frequent Visitor

Re: problem with query and ODBC

The ODBC is a SQL Server that is managed by IT department

 

1. Why don't connect directly via ODBC source from PowerBI

 

It's impossible to directly connect with the ODBC source from PowerBI because this one only shows the ODBC "client" and not "system"

Capture20191025_1.PNG

 

Capture20191025_2.PNGCapture20191025_3.PNG

 

 

Thus, I have to create an Access Database with the ODBC tables in in. Happily, I had this before I begin using Power BI.

Brusselaar Frequent Visitor
Frequent Visitor

Re: problem with query and ODBC

2. 

 

In my access Database, I have thus the ODBC tables :

 

Capture20191025_4.PNG

 

Power BI don't see this tables. Thus I have to find a solution permitting to access the data's.

 

And I create queries. Queries that copy in a local table (that works) and queries that are just selections queries like this one :

Capture20191025_5.PNG

 

Before, when I was connecting that type of query, that was good. But it doens't works anymore.

 

I have this error message :

 

Capture20191025_6.PNG

 

Thank for your help and your time

 

Regards

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 326 members 2,714 guests
Please welcome our newest community members: