Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
hina
Frequent Visitor

configure Access Database data source (ODBC) in data gateway

Hi

 

I am trying to add access database as data source in my data gate, as for schedule referesh for my data set (data gate way is disabled.). But when i try to add access data source as ODBC data source, i get the error as "The 'Driver' property with value '{Microsoft Access Driver (*.mdb, *.accdb)}' doesn't correspond to an installed ODBC driver.". although my ODBC data source is working fine and i am able to connect to it. Please any hints....

4 REPLIES 4
hina
Frequent Visitor

Hi

 

I have created MS Access ODBC data source and connected with it. but when i trie to add it as data source in MS BI Data Gate way, i am getting following error: "The 'Driver' property with value '{Microsoft Access Driver (*.mdb, *.accdb)}' doesn't correspond to an installed ODBC driver.".

Below is my connection string:

Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\dat207x\PowerBI.accdb;

 

please any quick help?....

Does it work when connection from pbi desktop

yes it works, when i try to connect it though BI Desktop....

hina
Frequent Visitor

Hi

 

I am working on sample Access database with power Bi. When i try to added MS Access data source in data gate way, i get the error "The 'Driver' property with value '{Microsoft Access Driver (*.mdb, *.accdb)}' doesn't correspond to an installed ODBC driver.". I tested the data source with other tools and it working and connected. any help or idea please?????

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.