Hey @kbruce, when it comes to getting data out of Nexpose for heavy read operations - such as a BI tool - our primary recommendation is to leverage the Data Warehouse functionality as it was designed for this specific purpose by providing the ability to get recent and historical snapshots of your VM scan data.
If it’s not possible to use the Data Warehouse feature then the next best option may be to set up scripts to pull data from the console’s reporting data model and pushing it directly into PowerBI. We’ve put together an example of how fetching bulk data can be accomplished with a Python script here and it could be extended with different SQL queries to get the data you are most interested in.