Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Integration with Tenable

Hello All – I am looking for someone who has been able to export data out of Tenable and import it into PowerBI.

 

  • What is Tenable -  A cloud based company that helps organizations to manage & measure their cyber exposure
  • What data to export -  Vulnerabilties and Assests


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.

Has any one worked out an integration between Tenable & PowerBI before, if so, please let me know.

We really do not want to reinvent the wheels here.. We need some help here..

 

Thanks,

Harsha Beeram

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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