EnergyPlus™ is a whole building energy simulation program that engineers, architects, and researchers use to model both energy consumption and water use in buildings.
I have been looking into processing the HTML results generated by EnergyPlus (through OpenStudio if that is relevant) in Microsoft PowerBI. One issue I ran into is that when importing the data, PowerBI fails to pull the table name. Upon doing some research and testing it appears that PowerBI looks for the preceding header to name the tables.
Details
My suggestion is a minor change to the HTML generation (eplustbl.html), by replacing the bold tag around the titles for the tables with a header tag (it seems like any header tag works h1, h2, h3, etc.) PowerBI will be able to properly label the tables it imports.
I did some testing and found using the \<h4> tag along with removing one of the preceding and the two following line breaks was a near-perfect match to the existing formatting:
Checklist
Add to this list or remove from it as applicable. This is a simple templated set of guidelines.
jmarrec
commented
4 months ago
Issue overview
I have been looking into processing the HTML results generated by EnergyPlus (through OpenStudio if that is relevant) in Microsoft PowerBI. One issue I ran into is that when importing the data, PowerBI fails to pull the table name. Upon doing some research and testing it appears that PowerBI looks for the preceding header to name the tables.
Details
My suggestion is a minor change to the HTML generation (eplustbl.html), by replacing the bold tag around the titles for the tables with a header tag (it seems like any header tag works h1, h2, h3, etc.) PowerBI will be able to properly label the tables it imports.
I did some testing and found using the \<h4> tag along with removing one of the preceding and the two following line breaks was a near-perfect match to the existing formatting:
Checklist
Add to this list or remove from it as applicable. This is a simple templated set of guidelines.