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!
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.