Excel 2013 - Import From Web with Basic Auth - Display issue

Hello all,

Im having an issue with Import From Web option in Excel 2013, which occurs only when loading an Xml file through a Web Url that needs a Basic Authentication.

Loading an XML file through a web service of mine, I have some data nicely displayed as a table in Excel.

But loading the same XML Data with an API with Basic Auth, the Load From Web form ask me for the login/pwd, it loads well the data, but not nicely displayed as a table in Excel,

Is there any workaround for this issue?

Thx for any help, opinion on this,

michael