Hello,
I have been trying unsuccessfully to make a connection from Power BI to Access. My Access database is an mdb backend that is linked to a accdb. I tried using the Access connector in BI and have selected both file types. It makes a connection using accdb and mdb but when I click on a table it says the table is empty. I googled and found several that said to use the ODBC or OLE DB. When I tried OLE DB and use the connection string: provider=Microsoft.ACE.OLEDB.16.0;data source="S:\Access Applications\BackEnd_Tables\Facilities_v07.accdb" I get a connection but only to the tables that were created in the front end.
For ODBC, I created a data source 64-bit pointing to the folder that houses both Access files. If I select the mdb, and a table I get a message: DatSource.Error: The table has no visible columns and cannot be queried.
I'm really at a loss as how to connect the db. Googling also mentions 32-bit driver but I know I have pointed to the 64-bit. Unfortunately, I do not have Admin access to my PC. If someone could suggest the best method and what needs to be done, I can put a ticket in to our IT department. Thank you.
I have been trying unsuccessfully to make a connection from Power BI to Access. My Access database is an mdb backend that is linked to a accdb. I tried using the Access connector in BI and have selected both file types. It makes a connection using accdb and mdb but when I click on a table it says the table is empty. I googled and found several that said to use the ODBC or OLE DB. When I tried OLE DB and use the connection string: provider=Microsoft.ACE.OLEDB.16.0;data source="S:\Access Applications\BackEnd_Tables\Facilities_v07.accdb" I get a connection but only to the tables that were created in the front end.
For ODBC, I created a data source 64-bit pointing to the folder that houses both Access files. If I select the mdb, and a table I get a message: DatSource.Error: The table has no visible columns and cannot be queried.
I'm really at a loss as how to connect the db. Googling also mentions 32-bit driver but I know I have pointed to the 64-bit. Unfortunately, I do not have Admin access to my PC. If someone could suggest the best method and what needs to be done, I can put a ticket in to our IT department. Thank you.