You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
Defect file added (list location of defect file here)
Ticket added to Pivotal for defect (development team task)
Pull request created (the pull request will have additional tasks related to reviewing changes that fix this defect)
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: