Unanswered

Migrating from MS Access to Power BI and Power Apps

(0) Share

Report

Posted on by Community Power Pla...

Hi,

Looking to migrate several MS Access applications (containing VBA code) all using the same database on a SQL server via linked tables.

The applications are used for Goods In and job creation for them, process flow/control and auditing during the jobs life cycle, as well as dispatch, stock control, along with pricing and invoicing.

These application also have a number of designed reports, including some that are invoices for customers.

Was looking to migrate the reports to Power BI and the forms with their VBA functionality to Power Apps, connecting to the existing SQL Server we host on site.

Of course, it would be great, if there was a way of exporting from Access and importing to Power BI, all the reports and their design, without having to recreate them from scratch in Power BI

Any advice, suggestions or pointers would be appreciate, as well as training literature and video, for a SQL/VB.net developer new to Power BI and Power Apps.

Regards,

Keith.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

There is a procedure for migrating MS Access to Dataverse and it will migrate the tables and the relationships. However, It does not migrate the VBA code or the forms and reports. The procedure is described here: https://support.microsoft.com/en-au/office/get-started-migrate-access-data-to-dataverse-013c8bab-7737-46ca-ad2e-892bbf26287d . I have done it several times and it works but can take quite a while if you have large tables. The tables in Access remain and there is an option to continue synchronization so the forms and reports in Access can still be obtained.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Drrickryp

Thanks for the reply,

As mentioned, the applications are already table linked to our own hosted SQL server, so no need to migrate to Dataverse at the moment, one potential cluster duck at a time! 😂

I would of be surprised it there was a migration process for MS Access/VBA applications to Power Apps,
So I am prepared to develop the new Power Apps against our current SQL server to start with, replacing aspect of the applications and their functionality, in parallel with the uses of the current MS Access applications, until I'm happy to switch over fully to Power Apps.

While I'll pull out as much of the business logic, functionality and hard coded data and relocate it to database tables, Store Procedures/Functions and views, so the new Power Apps really only need to act has user interfaces (canvas?), the reports design is the area I'm not great with and would love some form of migration process to Power BI, so I don't have to recreate from scratch, the reports with all their header, body and footer formatting and presentation.

Thanks again for the reply. 👍

Regards,

Keith.

Was this reply helpful? Yes No