From SQL to PowerBI : intermediary file

Good morning community,   after a lot of work, i have to admit i fail at solving this problem.   I currently have several Power BI files, each using a connector, and each being refreshed twice a ...