Automatic import per year date

Hi!

I've a ETL that extracts summarized data from my OLTP system. For example, all relevante sales information of 2016 january are the "reporting" schema with name "bi_sales_2016_01" table.

So, I need that PowerBI import all data from "2015-01" til "2017-07" (on 2017/07/31), and then tomorrow, also import data for "2017-08" and so on.

In short: I need to write a script that will import data. Is that possible? Any example available?

And after, how can I tell PowerBI that some group of tables are just a temporal split of certain information?