Forum Discussion

danieltodorov's avatar
danieltodorov
Frequent Visitor
6 years ago

Importing content from HTM files from Sharepoint folder

Hi Guys,   I'm trying to set up a data load, in Power BI desktop (and later in the service, as a dataflow), which merges daily extracts, that are stored in a Sharepoint folder, in HTM format. Each...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi danieltodorov deepikaajith ,

 

I came across the same issue, so when you locate your file in SharePoint, add a custom column to read the Text first, before Web.Page, if you have mutiple tables constructed in the HTM file, you may need to add a custom column to count the columns so you can find those tables you want. Let me know if you need any further help.

 
Source = SharePoint.Files("https://company.sharepoint.com/sites/Move/", [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Name], "VBFA_")),
#"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each Text.FromBinary([Content])),
Custom1 = Web.Page( #"Added Custom"[Custom]{0})
in
Custom1
deepikaajith's avatar
deepikaajith
Frequent Visitor
6 years ago

Hi,

Can you show us with some example so we can follow the sma esteps in our file?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi deepikaajith 

     

    How about you posting your M code and screenshot of your Power Query Editor (hide anything sensitive)? I can help from there.

    • lucamanunta's avatar
      lucamanunta
      Frequent Visitor
      2 years ago

      The solution proposed by Vera_33 worked as a charm for me! Thank you very much!

      Just to clarify, I did not even need to customise the code she proposed, so I just copy/pasted the following in the editor:

      #"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each Text.FromBinary([Content])),
    Custom1 = Web.Page( #"Added Custom"[Custom]{0}),
    Data = Custom1{0}[Data],