Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

MS Access

Submitted by on ‎04-22-2015 05:11 AM
MS Access is also a key data source. Power BI should be able to connect to the same. Access allows to create consolidated files from various data sources into one table which then can contain valuable data and business insight.
Status: Under Review
See more ideas labeled with:
11 Comments (11 New)
Comments
nishalit
New Member
‎04-22-2015 05:50 PM
Hi, we are working on supporting MS Access as data source that can be refreshed from. You can today connect to Access from Power Query or the Power BI Designer and build reports, dashboards on it. Soon we'll also release the capability to refresh these reports from within Power BI.
hughprysten
New Member
‎07-05-2020 03:00 PM
Awesome!
k_sathishprabhu
New Member
‎07-05-2020 03:06 PM
Waiting...
JanVW
Advocate I
Advocate I
‎07-05-2020 03:08 PM
A great alternative is publishing your Access DB as a webapp to Sharepoint Online. This will actually create a Azure SQL DB in the background which you can connect to directly from Power BI or PBI desktop.
ryanpaquette
New Member
‎07-05-2020 03:18 PM
Would be nice to embed a PowerBI frame right into an Access form... skip building access reports altogether / use PowerBI instead
aviokc20111
New Member
‎07-05-2020 03:26 PM
Is there is an update on Power BI to MS Access Create table / refresh data
dave_robinson
New Member
‎07-05-2020 03:38 PM
Any update on this?
dddrotts
New Member
‎07-05-2020 03:53 PM
Any updates?
dmoorehead
New Member
‎07-05-2020 03:57 PM
Power BI does support connection to Microsoft Access databases, but there are limitations. There is even a way it can be used with limited support for Power BI Service (online). Can you please clarify those limitations and the status by responding to the following more specific questions? Thanks for describing that useful workaround. For the following connection methods: A) import (embedded offline use), B) refreshable connection (import and scheduled or manual refresh), and/or C) live query supported? Which of the following cases are they supported with? 1) Use from Power BI Desktop app 2) Setup of connection from within Power BI Service (and/or Power BI Report Server?) 4) .pbix imported into Power BI Service (and/or Report Server?) 5) Installed Gateway connected to Access DB (for use from Desktop, Service, Report Server, and/or Mobile Apps?) 6) Mobile Apps (connecting to Gateway directly, to Service, or to .pbix on OneDrive, if possible?) Also, what, if any, further enhancements for Microosft Access support are under development now or planned? Thanks again for your help, Dan
rizzy_phillips
New Member
‎07-05-2020 05:04 PM
Can Power BI replace MsAccess function? I don't want to run two tools for users. They either use Power BI or MsAccess.