Store transient data in Power BI

[Chilli]

Hi,

for some reasons I need to store transistent data in Power BI.

Background: I use a Gateway for DB2 und upload Data daily. The Database doesn't store the data for the past days, just for the last day. So I want to save and collect them. 

Idea would be to upload data by query and add these to a consitent table in Power BI.

Is something like that possible?

Unfornuately I am not as good as whished in DAX to get an idea to solve this.

Thx in advance for help and greetings from Germany

Chilli

[lbendlin · Accepted solution]

The answer to this unfortunately is a hard no. Power BI has no memory.  You need to implement you historical data storage further upstream. For example in a SQL Server db or as CSV files.

[Chilli]

It seems you are absolutely right. I just found this to solve this kind of problem: Storing and using information from a dynamic data ... - Microsoft Power BI Community