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 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
I am trying to connect to Access database from Power BI but it keeps loading the data(screen keeps blinking) and then it stops responding. is it because data is huge?
what could be the reason?
I added the filter in MS access and saved which would send only filtered data to Power BI, once done with report development then removed the MS access filters and loaded all while publishing, you can also use top 100 records. There is no direct query option for MS access as source hence this should be used as import only.
Power BI service cannot refresh my dataset , which is Access DB in OneDrive, it gives the following error :
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 2010 Access Database Engine OLEDB provider may be required to read...
When I refresh my local pbi file, it doesnt give me this error as I already have database engine installed. But Power BI service cannot read my database in OneDrive, anyone knows why ?