Rapid 7 API to PoweBi - Data Refresh

[johnross]

Hi Everyone,

Im very new to to PowerBi so I appreciate your patience.

I have a dashboard that is connected to Rapid7 through API which gives me data for point in time. It means that everyday it gets refreshed, it only give you the current data and nothing else. There is no historical data so im not able to compare today and yesterday.

Is there a way to instead of overwritting the data from yesterday, it gets added to a table within

PowerBi before the new data comes in and gets displayed on the dashboard?

I saw that it can be done through powerautomate, get data from dashboard and add to an excel table but in my experience, powerautomate is not so reliable.

Any leads would be highly appreciated!

[cdobru]

Hi @johnross, I am trying to connect to Rapid7 through API, but I am getting an authentication issue despite using the key provided.  Can you walk me through how you connected? Thank you!

[v-yueyunzh-msft · Accepted solution]

Hi , @johnross 

According to my understanding of Power BI data refresh, each data refresh is according to the setting logic of the refresh (full or incremental) according to the existing data in the data source, extract data from the data source to cover the original data model, if the data source does not exist yesterday's data at the time of this data refresh, then yesterday's data will not remain in the data source when the data is refreshed. I think the only solution in Power BI is to use the "Export to CSV" function to save a CSV copy of the original data before data refresh, and then do a data refresh of today's data, you can refer to this document:

Export data from a Power BI visualization - Power BI | Microsoft Learn

For the specific logic of Power BI data refresh, you can refer to this official document:

Data refresh in Power BI - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly