Forum Discussion
Access Database in Power BI Online
Hi Jame1212,
We are not able to directly import data from Access database to Power BI Online Service.
However, you can connect to Access database from Power BI Desktop by using “Get data>More>Database>Access database” option, create reports in it and save the Power BI Desktop(PBIX) file. You can then publish the PBIX file to Power BI Online service or connect to the PBIX file via “Get data>Files” option of Power BI Online Service, this way, you are able to develop a dashboard based on the MS-Access database.
Thanks,
Lydia Zhang
Hi
Even i am facing the same issue. If anyone has the solution to help on this topic. getting error message as below. i have tried to follow the steps as per its documentation but still no luck . I am facing issue while refreshing the database.
Underlying error code: -2147467259
Underlying error message: Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read 'xxxxxx.accdb'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataSource.NotFound
Cluster URI: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
Activity ID: 713f9574-c123-4075-abba-e7c74545a8db
Request ID: 04d77b35-c619-f28f-f4f6-79b1771cc285
Time: 2022-06-28 12:02:37Z
Power bi service can not load Access DB with out driver. For that you have to gateway where Access driver is installed. Simply if you are able to open the access db file then use that systeam for personal/standrd gateway for this purpost or install only Access DB driver on system DNS.