Forum Discussion
JakubWiniarczk
6 years agoFrequent Visitor
PowerQuery - Web.Page(File.Contents) - encoding
Hey Everyone ! I need some help with 'Web.Page(File.Contents' in Power Query. I'm importing some .html file which has xml structure. In the file I can see information about encoding and xml stada...
Greg_Deckler
6 years agoCommunity Champion
Curious why you are using File.Contents instead of XML.Document? XML.Document you can specify the encoding:
https://docs.microsoft.com/en-us/powerquery-m/xml-document
- JakubWiniarczk6 years agoFrequent Visitor
Hye,
thanks for the quick reply.
When I tried to open HTML file like XML - system automatically changing xml.content into web.page file content.
When I've changed the file extension for .xml - there is some problem with correctly parsing so I can't use it.
Regards!
- JakubWiniarczk6 years agoFrequent Visitor
Hey
I fixed the problem by converting a file from windows-1250 into UTF via iconv ( linux ).
Thanks a lot!