POWER BI create all not manually but using code

Question

i'd want to know if is possible use code for create all schema of power bi (tables, name of all columns). This becouse i've several db with a schema like this:

tables with same structure that contains data (example: product(column name X01) , customer(column name X02), qty (column name X03), amount (column name X04), month (column name X05) etc. a table that contains the name of all tables with data (with the same structure) example named TAB1 a table that contains the name of all columns inside tables data example named TAB2 (example X01 product, X02 customer, etc.)

So what i'd like to do (if possible) is to import all tables specified in TAB1 change the name of columns as specified in TAB2

There is a way to do all this via code and not manually, if so, what is the language and where i can find some resources ?

thanks

i've tried to search in internet but i've not found anything