Prepare Data lake for Microsoft BI

We are preparing Microsoft BI reports from our system , we currently do it using MS Excel for data We want to prepare a data lake (or whatever is suitable) so the Microsoft BI can read from it live and historical data.

In our system GPSGATE you can use APIs to extract data for the data lake , we will share with you what data we need from the system to be used in the BI reports.

Please show your experience on similar projects .

Regards