Uploading Data into a SQL Table

[Razorbx13]

I have an empty SQL Table that my DBA created in our data warehouse and was wondering if there is a way to load data into the table from and Excel sheet using the desktop app.  I know I can import the Excel sheet to create a table using the Desktop app, but if I already have the structure of the table in my model, can I load data into that table?  Thanks!

[kentyler]

You might be able to use the M query language in Power Query. This is an example post about an M function that can insert rows in one table from rows in another table.
https://docs.microsoft.com/en-us/powerquery-m/table-insertrows

Power BI is easy to learn, but it has hard parts. I'm a personal Power Bi Trainer I learn something every time I answer a question How to Get Your Question Answered Quickly