Forum Discussion
DataFormat.Error when refreshing Access database in PBI Service
ok, atlast I solved this annoying error, and this is why and how:
- PBI desktop is OK to refresh access files, so nothing wrong with the database itself
- PBI service cannot refresh the database though all settings are OK -> there is something wrong with the connection
- While I check the connection - On premises data gateway - I found this https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-local-drive. And I see one of the data source that the gateway supports is ODBC
- Then I try Microsoft Access Database Engine at https://www.microsoft.com/en-us/download/details.aspx?id=54920
- Then atlast it works!
Hi Anonymous
Can you please confirm that you have got the 64bit access drivers installed?
I have installed Microsoft 365 Access Runtime x64 and restarted my computer, but there's still be the error.
Updated: After installing the program, I can't even open an Access file, then I have to remove it