I am migrating a SQL Server based system to Power Apps, and for this I need to move the data from the SQL Server database to Dataverse. I can't use any third-party integrators (like Kingwaysoft), I have available Microsoft Office (Excel, Access) and a Power Apps premium licence. I have been able to move the data from SQL Server to Access using Access import tool, and from there to Dataverse using an Excel template. The elusive part has been to recreate the relationship between tables.
I was able to migrate the tables and their relationship (one to many) following these steps: