Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Store data obtained in reports

What I want to do is, without assembling a previous BigData architecture, but they are very simple queries that serve as data extraction after I do a transformation and calculation of the data. I would like to be able to store the data day by day that I show shown in the reports to create trend charts.

Can this be done in PowerBI? Or do I need to mount an entire architecture behind it that has all these values stored day by day and PowerBi tool only from Businnes Intelligent?

I have 2 different databases totally as a data source.

I am starting in this bi world and I do not know very well how to mount an architecture, if it is worth it for what I have to do but I do not know if it will be necessary to create the trends that ask me.

Thanks a lot.

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Well, whether or not your data qualifies as requiring a "Big Data" I can't say. But, if you want to do what you are saying without a bunch of pre-processing of data, you could always insert an R or Python step in your queries to export your data to a file for example. Then you would have a log of the data for every time your data refreshed. Difficult to be very specific with the information provided.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      That's exactly what I'd need.

      Before the data is updated, export it. I'm told what would I be with Phyton or R? Where should I do it?

      Do you advise me to have a previous bbdd where I do all the transformations and here store the data as I want?

      I'm a little lost in how to store this data.

      Thanks a lot.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago

        Well, what I am proposing is kind of the opposite, you would store the data after you import it versus export the data before you import the new data, but should end up the same result. You would do this in the Power Query Editor and add an R step or Python step to your query(s).

         

        Difficult to say how you store it. CSV's are always popular, they avoid you having to know about databases. You could simply grab a timestamp and name the file that, so like 20200505000815AM.csv for example.