Power Apps

Fri ( 29/08/2025 02:11:25 )

No, it’s not possible to directly connect a Microsoft Power App to an Access Database.

Power Apps is designed to work primarily with cloud-based data sources. Here are some examples of data sources that Power Apps can connect to:

  • Microsoft Dataverse
  • SharePoint
  • Excel (stored on OneDrive or SharePoint)
  • SQL Server
  • Office 365 services (Outlook, Users, etc.)
  • Azure SQL Database
  • Custom APIs (which can connect to on-premises data via a gateway)

If you need to use Access data within Power Apps, you should consider the following methods:

  1. Migrate Access data to SQL Server: This is the most common and recommended approach. Migrate your Access data to SQL Server, and then connect Power Apps to SQL Server.
  2. Export Access tables to SharePoint lists: You can export your Access tables to SharePoint lists, and then connect Power Apps to those SharePoint lists.
  3. Export Access data to Excel: Export your Access data to an Excel file, save it on OneDrive or SharePoint, and then connect Power Apps to that Excel file. (This is suitable for smaller datasets.)

These methods will allow you to leverage your Access data within a Power App.

[ Database Migration using MySQL Workbench ]

Database > Migrate Data >

Source Database System: Microsoft Access

Connection Method: ODBC(Open Database Connectivity)

ODBC Data Source: access file

Target Database System: somedb

Host, Port User, Password

Posted by
Uncategorized