Rapid 7 API to PoweBi - Data Refresh

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