Power BI Integration with Tenable

The issue that I see is that Tenable does not provide an API with GET method.

They only have API’s with POST.

Tenable documentation has shown some ways to export their data – One way is using post REST API and the other is using a Python Script. I have tried using their python script in PowerBI and it errors out with a TimeOut error. The script takes more than 40 minutes to run. The reason for the long time, is that the script is trying to download everything out there.. As you can see in the below code, there are no filters… Below is the script:

from tenable_io.client import TenableIOClient

client = TenableIOClient(access_key=’xxxxxxxxxxxxxx',secret_key='zzzzzzzzzzzzzz')

assets = client.export_helper.download_assets(chunk_size=1000, has_plugin_results=True)

Someone from the BI community, shared that they created a PowerShell module that imports the data into SQL and normalizes the data, from which we could create BI reports. I am looking for a solution where I could have a powerquery within BI and everytime I hit refresh button, it could reach out to Tenable to get the latest data