Forum Discussion
Combine HTML Binaries from SharePoint
So I've actually ended up answering my own question, more through luck than judgement! I turned on the "New web table inference" Preview Feature. After doing that, the out-of-the-box combine binaries feature suddenly worked on my SharePoint HTML files!
Hi adamsharma
I am trying to do the same, but Power BI does not recognize the HTML binary to continue with the combine action. Could you please share the steps you followed to do this?
Hi dosorio. Apologies for the slow reply. So firstly I went to Options and Settings -> Preview features and turned on "New web table inference", then restarted Power BI Desktop. From there it was simple:
1) Create a new data source of type "SharePoint Folder" and point to the relevant SharePoint Site URL
2) Use the query editor to filter on the "Folder Path" column to select only the specific folder containing the HTML files you want to include
3) Click the double-down arrow "Combine Files" icon in the Content column header
4) Select the relevant table from those that Power Query has extracted, containing the content you want from the HTML file
5) Press OK!
You should then be able to shape and transform the data as with any other data source and load into the data model once ready.