DataFormat.Error: ODBC--connection to failed

[EdBI16]

Hi everyone,

I'm currently trying to connect to queries created in an Access database, however, I keep getting this error: DataFormat.Error: ODBC--connection to failed.

I can actually connect to the tables where all the information is in the Access database, but when I try to upload an specific query created in the Access database it doesn't work. This Access database also has connections to an SQL Server, that I was also able to connect to.

I have a 64-bit System DSN connection in the ODBC and I also have the Power BI 64-bit version. Those were some recommendation in other posts I read but still doesn't work.

Any recommendations to load queries from the Access database would be great as I'm struggling to find what the problem is. 

Thanks in advance for your time and help.

Ed

[Anonymous]

Hi @EdBI16 ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[Anonymous · Accepted solution]

Hi @EdBI16 ,

You may check the related steps Table.TransformColumnTypes in The Advanced Editor.

Best Regards,

Stephen Tao

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