cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
polar Occasional Visitor
Occasional Visitor

How to render a large HTML file in Power BI

Greetings,

 

I have an HTML page with 1.2 million characters of code which renders text and graphs. The task is to show the page in Power BI. Whatever has been tried so far (below), is compromized by the Power BI text field size mimitation of 32.8K characters:

 

-HTML viever visual with straight pointing to the HTML file on local drive - 32.8K limit

-Saving HTML code as a VARCHAR(MAX) field in an Azure table and Import storage mode - 32.8K limit

-Saving HTML code as a VARCHAR(MAX) field in an Azure table and DirectQuery storage mode - no 32.8K limit, but very slow, never finishes rendering

-Building tiles in PBI portal - 32.8K limit

-Tried creating the experience in PowerApps but not a great expert there yet

 

Basically, I need to show the page as it renders in a browser, displaying various analysis aspects of ML experiment. Any ideas? Thanks! 

 

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: How to render a large HTML file in Power BI

@polar,

I am afraid that it is not possible to render all the 1.2 million characters in Power BI. As your post, there is a text limitation.  There is an idea about HTML visualization without truncation, please vote it up.

To workaround this issue, you can upload the html file into OneDrive, share it to everyone in OneDrive, then create a table with  the shared link in Power BI Desktop, set data category of the column to Web URL. Then create a table visual in Power BI Desktop, this way, when you click on the link, you can view the html contents in web browser.
Capture.PNG1.PNG

Regards,
Lydia

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