cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GunnerJ
Helper V
Helper V

How to display HMTL file content via Powerbi desktop

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

1 ACCEPTED SOLUTION
v-diye-msft
Community Support
Community Support

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.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

2 REPLIES 2
v-diye-msft
Community Support
Community Support

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!

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
v-diye-msft
Community Support
Community Support

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.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors