How to make migration easier when the data source change?

Hi,

I have multiple dashboards and in each dashboards we use multiple tables and measures. These dashboards pull data from SQL Sever currently but now we want to migrate the current data to Hive. Table names are will be different but the columns name will be the same. 

I know how to change the data source but it would be tedious to go through each table "Navigation" step to change the table name.

I have looked at this thread Solved: Changing data source, how to make the migration (e... - Microsoft Power BI Community but it seems there's no other way than go through each table one by one. It's been 3 years since this question was posted, I want to check: 

1. is there any way to change the table name in Navigation step?

2. if not, how can I get the list of table names that is used in SQL Server for my dashboard?