Record data for trend

[MattBH]

Hi all,

I have an on-prem sql database connected to PowerBI, and its updating every day.

In the model I have a table called occupancies_RentCalculation and a field called EffectiveRentBalance.

This field updates each day displaying a new number.

Once a week I want to be able to capture this number, store it in a new table with a date, so I can create a trend visual.

thanks!

[Fowmy · Accepted solution]

@MattBH 

No, Power BI doesn't store data itself. Instead, it queries data from the data source every time a refresh occurs, in the case of import mode. For direct query, it queries directly from the data source. Therefore, I suggest storing this data in your source system, such as SQL Server or any other appropriate source.