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
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],