ETLinPOWERBI

Hi,

Is there a basic Extract load facility available in Power BI service. If we want to do a data collection of sanpshot of data every day (ex how many customers were on an online account everyday.This number changes\fluxtuates every minute and everday the count is different and we do not have history in database).This can be done as simple query below:-

Slect date,count(customers) from TableA

Output:-

1/1/2017  100

1/2/2017  98

1/3/2017 102

Can we use Power BI for this or we have to use a seperate ETL tool?

Please advise.

Thanks!!