Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone,
I work with HR data in Power BI and historical queries can be problematic with how the central HR database is designed. For now, my Power BI reports only show the current-day data. I'd like to store the most important data chunks from these reports every day by aggregating & summarizing them, so I can analyze them later or create reports for historical analyses.
What would be the best way to do this? Is it creating a database on my computer locally (I'm sure servers are better for this, since storage is a concern) that pulls data from the HR database itself, or can I generate data from Power BI datasets themselves?
The latter would be preferred, because I do a lot of tidying-up in Power Query. If the latter is indeed possible, how would I automate extracting the data to a new database from PBI datasets to a new database? Python? An in-built Power BI tool? Anything else I'm not aware about?
Thank you.
Hi @SoundChimera ,
Do you mean data archiving that refreshes data while retaining historical data? Unfortunately, if so, Power BI can't do that.
Best Regards,
Jay
Hey, thanks for the response.
I've looked into Dataflows and that looks like a solution I can use to store data daily at a regular interval in a specific way. Haven't looked much into it though - but can Dataflows help me achieve my goal?
For now, I've decided to go with the Python route to append data daily to another database.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
62 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
71 |