henrypost (Community Member) asked a question.
Automated PowerBI reporting
I have a series of PowerBI reports related to Veracode Security Labs training that I built out that take a list of learners, what month's course they're learning on, and if they've finished that course.
Currently, this is all manually copy-pasted from an HTML table (top left) into a spreadsheet and ingested by PowerBI.
I'd love to automate this if I can just pull data from a REST API. Is this possible?
.png){kind=logo}
EDIT: There's also an issue with CSV export - It doesn't show if a user is late/completed with the training, so the CSV export feature is useless to me for the purpose of my report-building, and I must instead copy-paste the HTML table from the website.
hello @henrypost (Community Member)
The best way to do that is scripting on Sec Labs APIs which you can see here: https://apidocs.hunter2.com/#apis
I thing you can create script to collect information and then push to Power BI