Forum Discussion
Record data for trend
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!
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.
1 Reply
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.