Forum Discussion

samye228's avatar
samye228
Helper I
2 years ago
Solved

DataSourceError Access Database

Hello,  This may not be the right forum. I'm accessing Power Query from Power BI. I have an ODBC connection setup for an Access database. The Access database was created in 1996 and migrated to Offi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi samye228 ,
Based on your description, you are experiencing compatibility issues with older tables in the Access database. You can try the following steps to resolve this issue:
First, make sure that the bit size of the Access database engine (32-bit or 64-bit) matches the bit size of Power BI Desktop. A bit version mismatch may cause connection problems.
Power Query Access database connector - Power Query | Microsoft Learn
Second, make sure you have the latest ODBC driver installed. Sometimes older drivers may not fully support newer versions of the Access database.
You can check out the following documents for more information
Microsoft Access 365 ODBC Connection error - Microsoft Community

Troubleshooting an ODBC-based Power Query connector - Power Query | Microsoft Learn

Power Query ODBC connector - Power Query | Microsoft Learn

Solved: ODBC Connection Error - Driver Error - Microsoft Fabric Community

 

Best regards,
Albert He

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