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!
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!