Forum Discussion
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 ...
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....
