How to display HMTL file content via Powerbi desktop

[GunnerJ]

I have an HTML file saved on an app server and when I "GET DATA" and choose folder and then enter the path I can only display the name of the path. I want to essentially execute the file and fun it within Powerbi. Am I using the wrong "GET DATA" source or maybe not using the correct visual? 

Any help at all would be appreciated.

Thanks

[ChazTime]

Reviving old post...

Curious if this has worked for anyone? @v-diye-msft when I use the above formula I receive the error shown below. I have changed the .html file to a .text and receive the same error regardless of file type. My connection is to a Sharepoint folder.

[ChazTime]

I figured it out. When creating the custom column, I used the below code, then used HTML Viewer visual to view the output.

html_content = Text.FromBinary([Content])

[v-diye-msft]

Hi @GunnerJ 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution if you feel that makes sense. if not, please share more details about your question, I'd like to provide further support. thanks!

[v-diye-msft · Accepted solution]

Hi @GunnerJ ,

It's not able to connect the html file currently. 

As a workaround,  you could store HTML into a file, then, store file path with binary datatype. Loading data into Power BI desktop, you would get a column (named as Column1) listing HTML file path like C:\Users\username\Desktop\filename.txt, then, you could add a custom column in Query Editor mode with below M code:

Custom column=Web.Page(File.Contents([Column1]))

Based on above steps, expand the new custom column, you can get the desired html table.