Excel wroksheet to sql database?

Hello everyone,
I am trying to export the data from my Excel worksheet (.xlsx) to Microsoft SQL for later use in Power BI

challenges:-

-excel cells have dynamic links and data in cells continuously updated every minuet.
-auto mate in a way so dont have to manually run SSMS import wizard.