Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @Anonymous ,
You can also learn more about: historical data preservation using power Bi dataflow
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.
Thank you very much for your almost immediate support.
I think that in the end I will collect the data from the bbdd and insert it into an intermediate database and this is where I will do the data transformations and with a Java or .Net program or BBDD script I will store the values of the reports day by day.
Thank you!!!!!!!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
120 | |
105 | |
77 | |
74 | |
52 |
User | Count |
---|---|
145 | |
109 | |
107 | |
90 | |
64 |