It's a little more work than my example but TekLink's solution is much more scalable and reliable. Truly, they did a great job - presenter, Mario Arias, gives you everything you need to build a custom connector to PowerBI.
Excel is encoded with all kinds of special characters for Microsoft to interpret the file. Give CSV a try. Also, make sure your line items show up as columns without any other dimension nested. Rows should be your lists.
Lastly, if you have time, try using some of the longer term suggestions I provided you.