Forum Discussion

Chilli's avatar
Chilli
Helper I
5 years ago
Solved

Store transient data in Power BI

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

Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    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.