Have you guys have any experience integrating Anaplan data model into Power BI? If you do, please share. Our company is planning to integrate Anaplan data soon, and I am just researching for a proof of concept.
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.