cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

File read issue > how to read this?

Dear community.

 

I have a set of files that comes from SAP BW - we cannot interface directly - as a broadcast to my outlook every day.

It arrives in my mail as a ZIP, with within a file with xls extension.

 

However, it is no a true excel file, but rather similar to XML. I found this out when right click > open in notepad.

If i open the file with Excel it will tell me that te file format and extension dont match, but when  i click yes to continue the file opens and i see an excel table. When i save the file then to excel with save as excel, it is much much smaller and opens correctly next time

 

Unfortunately, i dont want to every day extract all zip files and then open > save as excel everyday for all files. I want to read the file in Power BI. Get file as XML and Excel dont seem to work.

 

Can anyone please take a look at the file in the link below and advice? I removed all data lines but one to keep te file small and without confidential data.

 

https://ufile.io/o8y3c

 

1 REPLY 1
Highlighted
Super User IV
Super User IV

Re: File read issue > how to read this?

Try opening it as an HTML page.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors