How do I add a table from excel (not a power pivot) table

Just make sure your data in the Excel spreadsheet is formatted as a TABLE.  Then log into Power BI and upload the spreadsheet into your Power BI workspace using Add data.

See this video for more info.

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-5-2-upload-excel/